APPS.INV_UI_RCV_LOVS dependencies on PO_REQ_HEADERS_TRX_V

Line 788: po_req_headers_trx_v prh, -- CLM project, bug 9403291

784: prh.description,
785: NULL,
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

Line 828: po_req_headers_trx_v prh, -- CLM project, bug 9403291

824: prh.description,
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

Line 856: po_req_headers_trx_v prh, -- CLM project, bug 9403291

852: prh.description,
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

Line 2402: po_req_headers_trx_v prh, -- CLM project, bug 9403291

2398: NULL FIELD13,
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

Line 2884: po_req_headers_trx_v prh, -- CLM project, bug 9403291

2880: NULL FIELD13,
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