DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 115: source_organization_id po_requisition_lines_all.source_organization_id%type,

111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,

Line 116: source_subinventory po_requisition_lines_all.source_subinventory%type,

112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,

Line 117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,

113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,

Line 118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,

114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,

Line 3221: po_requisition_lines_all prl,

3217: mtl.comms_nl_trackable_flag ib_flag,
3218: mtl.lot_control_code,
3219: hao.name org_name
3220: from rcv_transactions rcv,
3221: po_requisition_lines_all prl,
3222: po_requisition_headers_all prh,
3223: mtl_system_items mtl,
3224: hr_all_organization_units hao
3225: where rcv.requisition_line_id = prl.requisition_line_id

Line 4637: po_requisition_lines_all prl,

4633: mtl.comms_nl_trackable_flag ib_flag,
4634: mtl.lot_control_code,
4635: hao.name org_name
4636: from rcv_transactions rcv,
4637: po_requisition_lines_all prl,
4638: po_requisition_headers_all prh,
4639: mtl_system_items mtl,
4640: hr_all_organization_units hao
4641: where rcv.requisition_line_id = prl.requisition_line_id

Line 7039: po_requisition_lines_all prl,

7035: trl.txn_source_id
7036: from oe_order_lines_all oel,
7037: wsh_delivery_details dd,
7038: wsh_serial_numbers dsn,--Added to fix 3801614
7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,
7042: hr_all_organization_units hao,
7043: hr_all_organization_units hao1,

Line 7096: po_requisition_lines_all prl,

7092: trl.txn_source_id
7093: from oe_order_lines_all oel,
7094: wsh_delivery_details dd,
7095: wsh_serial_numbers dsn,--Added to fix 3801614
7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,
7099: hr_all_organization_units hao,
7100: hr_all_organization_units hao1,