eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPMECS dependencies on PO_DISTRIBUTIONS_ALL

Line 521: , po_distributions_all POD

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
524: AND POD.destination_organization_id = MP.organization_id
525: AND POD.destination_type_code = 'INVENTORY'

Line 1022: , po_distributions_all PD

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'
1026: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))

Line 1054: , po_distributions_all PD

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'
1058: AND AIP.accounting_date

Line 1126: , po_distributions_all PD

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'
1130: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))