SCH_REC_SERIAL_NUMBER_DTLS

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

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

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