APPS.INV_UI_RCV_LOVS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 7610: po_req_Distributions_All prd

7606: rsh.shipment_header_id shipment_header_id
7607: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291
7608: rcv_Shipment_Lines rsl ,
7609: rcv_shipment_headers rsh,/* Added by Bug9257750 */
7610: po_req_Distributions_All prd
7611: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7612: AND rsh.shipment_header_id = rsl.shipment_header_id /* Added by Bug9257750 */
7613: AND l_From_lpn_Id IS NOT NULL
7614: AND EXISTS

Line 7696: po_req_Distributions_All prd,

7692: SELECT rsl.Item_Id,rsh.shipment_num shipment_num, /* Added by Bug9257750 */
7693: rsh.shipment_header_id shipment_header_id
7694: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291
7695: rcv_Shipment_Lines rsl ,
7696: po_req_Distributions_All prd,
7697: rcv_shipment_headers rsh /* Added by Bug9257750 */
7698: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7699: AND rsh.shipment_header_id = rsl.shipment_header_id /* Added by Bug9257750 */
7700: AND l_From_lpn_Id IS NULL

Line 7780: po_req_Distributions_All prd,

7776: SELECT rsl.Item_Id,rsh.shipment_num shipment_num,
7777: rsh.shipment_header_id shipment_header_id
7778: FROM po_req_lines_trx_v prl,
7779: rcv_Shipment_Lines rsl ,
7780: po_req_Distributions_All prd,
7781: rcv_shipment_headers rsh
7782: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7783: AND rsh.shipment_header_id = rsl.shipment_header_id
7784: AND l_From_lpn_Id IS NULL

Line 7807: po_req_distributions_all prd

7803: AND EXISTS
7804: (SELECT 1
7805: FROM po_req_lines_trx_v prl,
7806: rcv_shipment_lines rsl ,
7807: po_req_distributions_all prd
7808: WHERE prl.requisition_header_id = p_reqHeaderID
7809: AND rsl.item_id = msi.inventory_item_id
7810: AND ( (l_from_lpn_id IS NULL)
7811: OR (l_from_lpn_id IS NOT NULL