DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on PO_LOOKUP_CODES

Line 272: PO_LOOKUP_CODES PLC,

268: poh.note_to_receiver ,
269: to_char(poh.org_id)
270: FROM RCV_SUPPLY RSUP,
271: RCV_TRANSACTIONS RT,
272: PO_LOOKUP_CODES PLC,
273: PO_LINES_trx_v pol, -- CLM project, bug 9403291
274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291
275: PO_HEADERS_trx_v POH, -- CLM project, bug 9403291
276: po_line_types plt,--BUG 5166887

Line 721: PO_LOOKUP_CODES PLC,

717: FROM RCV_SUPPLY RSUP,
718: RCV_SHIPMENT_LINES RSL,
719: RCV_TRANSACTIONS RT,
720: RCV_SHIPMENT_HEADERS RSH,
721: PO_LOOKUP_CODES PLC,
722: PO_LINE_LOCATIONS_ALL PLL,
723: HR_ALL_ORGANIZATION_UNITS_TL OOD
724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
725: , mtl_parameters mp,

Line 1116: PO_LOOKUP_CODES PLC,

1112: FROM RCV_SUPPLY RSUP,
1113: RCV_TRANSACTIONS RT,
1114: RCV_SHIPMENT_HEADERS RSH,
1115: RCV_SHIPMENT_LINES RSL,
1116: PO_LOOKUP_CODES PLC,
1117: PO_LINE_LOCATIONS_ALL PLL,
1118: mtl_parameters mp --BUG 5166887
1119: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'
1120: AND RT.TRANSACTION_TYPE <> 'UNORDERED'