APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1784: FROM po_req_distributions_all prd

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

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

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

Line 3438: FROM po_req_distributions_all prd

3434: (
3435: rsl.source_document_code = 'REQ'
3436: AND EXISTS(
3437: SELECT '1'
3438: FROM po_req_distributions_all prd
3439: WHERE prd.requisition_line_id = porl.requisition_line_id
3440: AND (
3441: p_project_id IS NULL
3442: OR(p_project_id = -9999

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

3450: OR rsl.source_document_code <> 'REQ'
3451: );
3452:
3453: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
3454: -- a full scan on po_req_distributions_all which is not good.
3455:
3456: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3457: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3458: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;