APPS.INV_UI_RCV_LOVS dependencies on PO_REQ_LINES_TRX_V

Line 790: po_req_lines_trx_v prl, -- CLM project, bug 9403291

786: to_char(prh.org_id) --
787: FROM
788: po_req_headers_trx_v prh, -- CLM project, bug 9403291
789: rcv_supply ms,
790: po_req_lines_trx_v prl, -- CLM project, bug 9403291
791: rcv_transactions rt
792: WHERE
793: prh.requisition_header_id = ms.req_header_id
794: AND prl.requisition_header_id = prh.requisition_header_id

Line 829: po_req_lines_trx_v prl -- CLM project, bug 9403291

825: null,
826: to_char(prh.org_id) --
827: FROM
828: po_req_headers_trx_v prh, -- CLM project, bug 9403291
829: po_req_lines_trx_v prl -- CLM project, bug 9403291
830: WHERE
831: Nvl(prl.cancel_flag,'N') = 'N'
832: AND prl.destination_organization_id = p_organization_id
833: AND prh.requisition_header_id = prl.requisition_header_id

Line 857: po_req_lines_trx_v prl -- CLM project, bug 9403291

853: null,
854: to_char(prh.org_id) --
855: FROM
856: po_req_headers_trx_v prh, -- CLM project, bug 9403291
857: po_req_lines_trx_v prl -- CLM project, bug 9403291
858: WHERE
859: Nvl(prl.cancel_flag,'N') = 'N'
860: AND prl.destination_organization_id = p_organization_id
861: AND prh.requisition_header_id = prl.requisition_header_id

Line 2403: po_req_lines_trx_v prl -- CLM project, bug 9403291

2399: lookup_code FIELD14 ,
2400: to_char(prh.org_id) FIELD15 --
2401: FROM fnd_lookup_values_vl flv,
2402: po_req_headers_trx_v prh, -- CLM project, bug 9403291
2403: po_req_lines_trx_v prl -- CLM project, bug 9403291
2404: WHERE flv.lookup_code = 'REQ'
2405: AND flv.lookup_type = 'DOC_TYPE'
2406: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2407: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2885: po_req_lines_trx_v prl -- CLM project, bug 9403291

2881: lookup_code FIELD14 ,
2882: to_char(prh.org_id) FIELD15 --
2883: FROM fnd_lookup_values_vl flv,
2884: po_req_headers_trx_v prh, -- CLM project, bug 9403291
2885: po_req_lines_trx_v prl -- CLM project, bug 9403291
2886: WHERE flv.lookup_code = 'REQ'
2887: AND flv.lookup_type = 'DOC_TYPE'
2888: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2889: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 7607: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291

7603: /* Bug 5581528 */
7604: (
7605: SELECT rsl.Item_Id,rsh.shipment_num shipment_num, /* Added by Bug9257750 */
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

Line 7694: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291

7690: /* Bug 5581528 */
7691: (
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

Line 7778: FROM po_req_lines_trx_v prl,

7774: -- This Select clause added by Bug9257750 to fetch the values of Shipment Number and Shipment Header id
7775: (
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

Line 7805: FROM po_req_lines_trx_v prl,

7801: AND (purchasing_enabled_flag = 'Y'
7802: OR stock_enabled_flag = 'Y')
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