DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_REQUISITIONS_INTERFACE

Line 3201: FROM po_requisitions_interface

3197: , project_id
3198: , task_id
3199: , source_type_code
3200: , unit_of_measure -- Bug 8524455
3201: FROM po_requisitions_interface
3202: WHERE requisition_header_id = p_header_id
3203: AND interface_source_code = 'CTO'
3204: UNION
3205: select prl.requisition_header_id

Line 3225: FROM po_requisitions_interface pri

3221: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'
3222: AND muom.unit_of_measure= unit_meas_lookup_code
3223: AND prh.interface_source_code = 'CTO' -- Bug 13580940
3224: and not exists (select null
3225: FROM po_requisitions_interface pri
3226: where pri.requisition_header_id = prh.requisition_header_id
3227: and pri.interface_source_code = 'CTO');
3228:
3229: -- Bug 13580940 added a condition to check the interface_source_code for 'CTO'