DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 522: , mtl_uom_conversions_view UOM

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'
526: AND NVL(PLL.closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CLOSED',

Line 1020: FROM mtl_uom_conversions_view UCR

1016: DELETE FROM cst_lists L
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

Line 1052: FROM mtl_uom_conversions_view UCR

1048: DELETE FROM cst_lists L
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

Line 1124: FROM mtl_uom_conversions_view UCR

1120: , I_REQUEST_ID
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