DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_LINES_ALL

Line 422: FROM po_lines_all pol, --CLM Apprvl

418: po2.LINE_NUM_DISPLAY --Base line num
419: -- ,pol.contract_type
420: ,lkp1.description
421: ,pol.LINE_NUM_DISPLAY
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add

Line 423: po_lines_all po2, -- CLM Apprvl

419: -- ,pol.contract_type
420: ,lkp1.description
421: ,pol.LINE_NUM_DISPLAY
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add
427: financials_system_parameters fsp

Line 533: FROM po_lines_all pol, -- CLM apprvl

529: pll.shipment_type,
530: --Bug 4950850 Added pll.amount
531: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
532: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
533: FROM po_lines_all pol, -- CLM apprvl
534: po_line_locations_all pll, -- CLM apprvl
535: mtl_system_items_kfv msi,
536: hr_locations_all hrl,
537: hz_locations hz,