DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on PO_REQUISITION_HEADERS

Line 760: po_requisition_headers prh,

756: prh.description,
757: NULL,
758: to_char(prh.org_id) --
759: FROM
760: po_requisition_headers prh,
761: rcv_supply ms,
762: po_requisition_lines prl,
763: rcv_transactions rt
764: WHERE

Line 800: po_requisition_headers prh,

796: prh.description,
797: null,
798: to_char(prh.org_id) --
799: FROM
800: po_requisition_headers prh,
801: po_requisition_lines prl
802: WHERE
803: Nvl(prl.cancel_flag,'N') = 'N'
804: AND prl.destination_organization_id = p_organization_id

Line 828: po_requisition_headers prh,

824: prh.description,
825: null,
826: to_char(prh.org_id) --
827: FROM
828: po_requisition_headers prh,
829: po_requisition_lines prl
830: WHERE
831: Nvl(prl.cancel_flag,'N') = 'N'
832: AND prl.destination_organization_id = p_organization_id

Line 2352: po_requisition_headers prh,

2348: NULL FIELD12,
2349: lookup_code FIELD13 ,
2350: to_char(prh.org_id) FIELD14 --
2351: FROM fnd_lookup_values_vl flv,
2352: po_requisition_headers prh,
2353: po_requisition_lines prl
2354: WHERE flv.lookup_code = 'REQ'
2355: AND flv.lookup_type = 'DOC_TYPE'
2356: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 2826: po_requisition_headers prh,

2822: NULL FIELD12,
2823: lookup_code FIELD13 ,
2824: to_char(prh.org_id) FIELD14 --
2825: FROM fnd_lookup_values_vl flv,
2826: po_requisition_headers prh,
2827: po_requisition_lines prl
2828: WHERE flv.lookup_code = 'REQ'
2829: AND flv.lookup_type = 'DOC_TYPE'
2830: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE