DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 122: source_organization_id po_requisition_lines_all.source_organization_id%type,

118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,

Line 123: source_subinventory po_requisition_lines_all.source_subinventory%type,

119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,

Line 124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,

120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,

Line 125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,

121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,

Line 3382: po_requisition_lines_all prl,

3378: mtl.comms_nl_trackable_flag ib_flag,
3379: mtl.lot_control_code,
3380: hao.name org_name
3381: from rcv_transactions rcv,
3382: po_requisition_lines_all prl,
3383: po_requisition_headers_all prh,
3384: mtl_system_items mtl,
3385: hr_all_organization_units hao
3386: where rcv.requisition_line_id = prl.requisition_line_id

Line 4798: po_requisition_lines_all prl,

4794: mtl.comms_nl_trackable_flag ib_flag,
4795: mtl.lot_control_code,
4796: hao.name org_name
4797: from rcv_transactions rcv,
4798: po_requisition_lines_all prl,
4799: po_requisition_headers_all prh,
4800: mtl_system_items mtl,
4801: hr_all_organization_units hao
4802: where rcv.requisition_line_id = prl.requisition_line_id

Line 7331: po_requisition_lines_all prl,

7327: trl.txn_source_id
7328: from oe_order_lines_all oel,
7329: wsh_delivery_details dd,
7330: wsh_serial_numbers dsn,--Added to fix 3801614
7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,
7334: hr_all_organization_units hao,
7335: hr_all_organization_units hao1,

Line 7388: po_requisition_lines_all prl,

7384: trl.txn_source_id
7385: from oe_order_lines_all oel,
7386: wsh_delivery_details dd,
7387: wsh_serial_numbers dsn,--Added to fix 3801614
7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,
7391: hr_all_organization_units hao,
7392: hr_all_organization_units hao1,