DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on PO_LINES_ALL

Line 519: , po_lines_all POL

515: UOM.conversion_rate))) *
516: (1 + I_PER_INC/100) + I_AMT_INC
517: FROM mtl_parameters MP
518: , po_headers_all POH
519: , po_lines_all POL
520: , po_line_locations_all PLL
521: , po_distributions_all POD
522: , mtl_uom_conversions_view UOM
523: WHERE MP.cost_organization_id = I_ORG_ID

Line 1021: , po_lines_all PL

1017: WHERE L.list_id = I_LIST_ID
1018: AND 0 >=
1019: (SELECT NVL(sum(quantity_invoiced * UCR.conversion_rate),0)
1020: FROM mtl_uom_conversions_view UCR
1021: , po_lines_all PL
1022: , po_distributions_all PD
1023: , mtl_parameters MP
1024: , ap_invoice_distributions_all AIP
1025: WHERE AIP.posted_flag = 'Y'

Line 1053: , po_lines_all PL

1049: WHERE L.list_id = I_LIST_ID
1050: AND EXISTS
1051: (SELECT 1
1052: FROM mtl_uom_conversions_view UCR
1053: , po_lines_all PL
1054: , po_distributions_all PD
1055: , mtl_parameters MP
1056: , ap_invoice_distributions_all AIP
1057: WHERE NVL(AIP.posted_flag,'N') = 'Y'

Line 1125: , po_lines_all PL

1121: , I_PROGRAM_APPL_ID
1122: , I_PROGRAM_ID
1123: , SYSDATE
1124: FROM mtl_uom_conversions_view UCR
1125: , po_lines_all PL
1126: , po_distributions_all PD
1127: , mtl_parameters MP
1128: , ap_invoice_distributions_all AIP
1129: WHERE AIP.posted_flag = 'Y'