APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1782: FROM po_req_distributions_all prd

1778: (
1779: rsl.source_document_code = 'REQ'
1780: AND EXISTS(
1781: SELECT '1'
1782: FROM po_req_distributions_all prd
1783: WHERE prd.requisition_line_id = porl.requisition_line_id
1784: AND
1785: (
1786: p_project_id IS NULL

Line 1799: -- a full scan on po_req_distributions_all which is not good.

1795: OR rsl.source_document_code <> 'REQ'
1796: );
1797:
1798: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
1799: -- a full scan on po_req_distributions_all which is not good.
1800:
1801:
1802: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1803: --table to store all RTId, quantity and original_rti_id for lot/serial splits

Line 3334: FROM po_req_distributions_all prd

3330: (
3331: rsl.source_document_code = 'REQ'
3332: AND EXISTS(
3333: SELECT '1'
3334: FROM po_req_distributions_all prd
3335: WHERE prd.requisition_line_id = porl.requisition_line_id
3336: AND (
3337: p_project_id IS NULL
3338: OR(p_project_id = -9999

Line 3350: -- a full scan on po_req_distributions_all which is not good.

3346: OR rsl.source_document_code <> 'REQ'
3347: );
3348:
3349: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
3350: -- a full scan on po_req_distributions_all which is not good.
3351:
3352: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3353: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3354: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;