SCH_REC_SERIAL_NUMBER_DTLS_V
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: VIEW
Columns
Name |
---|
HEADER_ID BUSINESS_UNIT_ID LINE_ID LOT_ID MFG_LOT_NUMBER SERIAL_ID MFG_SERIAL_NUMBER ORGANIZATION_ID INVENTORY_ITEM_ID SERIAL_NUMBER |
Query
SQL_Statement |
---|
SELECT hdr.header_id, hdr.business_unit_id, line.line_id , serial.lot_id, serial.mfg_lot_number, serial.serial_id,serial.mfg_serial_number, org.organization_id,line.inventory_item_id, inv_serial.serial_number FROM inv_serial_numbers inv_serial, fusion.sch_rec_headers hdr, fusion.sch_rec_lines line, fusion.sch_rec_serial_number_dtls serial, fusion.INV_ORG_PARAMETERS_V org WHERE hdr.header_id=line.header_id and line.line_id=serial.line_id and hdr.business_unit_id=org.business_unit_id AND nvl(org.project_reference_enabled, 0) != 1 and (inv_serial.serial_number = serial.mfg_serial_number or inv_serial.vendor_serial_number = serial.mfg_serial_number) AND inv_serial.inventory_item_id = line.inventory_item_id AND inv_serial.current_organization_id = org.organization_id |