[Home] [Help]
131: WHERE L.list_id = I_LIST_ID
132: AND EXISTS (
133: SELECT /*+ NO_UNNEST */ 'X'
134: FROM mtl_material_transactions M
135: , mtl_parameters MP
136: WHERE MP.cost_organization_id = I_ORG_ID
137: AND M.organization_id = MP.organization_id
138: AND M.inventory_item_id = L.ENTITY_ID
139: AND (
215: , I_PROGRAM_APPL_ID
216: , I_PROGRAM_ID
217: , SYSDATE
218: FROM mtl_material_transactions MMT
219: , mtl_parameters MP
220: WHERE MP.cost_organization_id = I_ORG_ID
221: AND MMT.organization_id = MP.organization_id
222: AND MMT.OWNING_TP_TYPE = 2
223: AND MMT.inventory_item_id = CICD.inventory_item_id
321: WHERE L.list_id = I_LIST_ID
322: AND NOT EXISTS (
323: SELECT 'X'
324: FROM mtl_material_transactions M
325: , mtl_parameters MP
326: WHERE MP.cost_organization_id = I_ORG_ID
327: AND M.organization_id = MP.organization_id
328: AND M.inventory_item_id = L.ENTITY_ID
329: AND M.transaction_source_type_id = 1
436: , I_PROGRAM_ID
437: , SYSDATE
438:
439: FROM /* Select and Round FROM clause */
440: mtl_parameters MP
441: , mtl_secondary_inventories MSI
442: , mtl_onhand_quantities MOH
443: , mtl_material_transactions MMT
444:
565: UOM.conversion_rate), 0, 1,
566: SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
567: UOM.conversion_rate))) *
568: (1 + I_PER_INC/100) + I_AMT_INC
569: FROM mtl_parameters MP
570: , po_headers_all POH
571: , po_lines_all POL
572: , po_line_locations_all PLL
573: , po_distributions_all POD
1092: (SELECT 1
1093: FROM mtl_uom_conversions_view UCR
1094: , po_lines_all PL
1095: , po_distributions_all PD
1096: , mtl_parameters MP
1097: , ap_invoice_distributions_all AIP
1098: WHERE NVL(AIP.posted_flag,'N') = 'Y'
1099: AND AIP.accounting_date
1100: BETWEEN NVL(I_FROM_DATE, AIP.accounting_date)
1158: , SYSDATE
1159: FROM mtl_uom_conversions_view UCR
1160: , po_lines_all PL
1161: , po_distributions_all PD
1162: , mtl_parameters MP
1163: /* BUG#8876268, BUG#12696671, code changes for IPV and NONREC_TAX */
1164: , (SELECT base_amount
1165: , quantity_invoiced
1166: , amount