DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_REQUISITIONS_INTERFACE

Line 3212: FROM po_requisitions_interface

3208: , quantity
3209: , project_id
3210: , task_id
3211: , source_type_code
3212: FROM po_requisitions_interface
3213: WHERE requisition_header_id = p_header_id
3214: AND interface_source_code = 'CTO'
3215: UNION
3216: select prl.requisition_header_id

Line 3234: FROM po_requisitions_interface pri

3230: and prd.requisition_line_id = prl.requisition_line_id
3231: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'
3232: AND muom.unit_of_measure= unit_meas_lookup_code
3233: and not exists (select null
3234: FROM po_requisitions_interface pri
3235: where pri.requisition_header_id = prh.requisition_header_id
3236: and pri.interface_source_code = 'CTO');
3237:
3238: