[Home] [Help]
518: SELECT organization_id,
519: default_cost_group_id cost_group_id
520: FROM mtl_parameters
521: ) CCGA,
522: mtl_interorg_parameters MIP
523: WHERE CCG.cost_group_id = CCGA.cost_group_id
524: AND NVL(CCG.disable_date, sysdate+1) > sysdate
525: AND CCG.cost_group
526: BETWEEN NVL(p_cost_group_from, CCG.cost_group)
1149: FROM mtl_supply MS,
1150: cst_item_list_temp ITEMS,
1151: cst_cg_list_temp CGS,
1152: mtl_parameters MP,
1153: mtl_interorg_parameters MIP,
1154: mtl_material_transactions MMT,
1155: rcv_shipment_lines RSL,
1156: mtl_system_items MSI_FROM
1157: WHERE MS.to_organization_id = p_organization_id
1251: RSL.shipment_line_id
1252: FROM mtl_material_transactions MMT,
1253: cst_item_list_temp ITEMS,
1254: cst_cg_list_temp CGS,
1255: mtl_interorg_parameters MIP,
1256: mtl_system_items MSI_TO,
1257: rcv_shipment_headers RSH,
1258: rcv_shipment_lines RSL
1259: WHERE MMT.transfer_organization_id = p_organization_id
1347: RT.shipment_line_id
1348: FROM mtl_material_transactions MMT,
1349: cst_item_list_temp ITEMS,
1350: cst_cg_list_temp CGS,
1351: mtl_interorg_parameters MIP,
1352: mtl_system_items MSI_FROM,
1353: rcv_transactions RT
1354: WHERE MMT.organization_id = p_organization_id
1355: AND MMT.transaction_action_id = 12
1448: RSL.shipment_line_id
1449: FROM mtl_material_transactions MMT,
1450: cst_item_list_temp ITEMS,
1451: cst_cg_list_temp CGS,
1452: mtl_interorg_parameters MIP,
1453: mtl_system_items MSI_TO,
1454: rcv_shipment_headers RSH,
1455: rcv_shipment_lines RSL
1456: WHERE MMT.transfer_organization_id = p_organization_id
1549: RT.shipment_line_id
1550: FROM mtl_material_transactions MMT,
1551: cst_item_list_temp ITEMS,
1552: cst_cg_list_temp CGS,
1553: mtl_interorg_parameters MIP,
1554: mtl_system_items MSI_FROM,
1555: rcv_transactions RT
1556: WHERE MMT.organization_id = p_organization_id
1557: AND MMT.transaction_action_id = 12
1649: FROM mtl_supply MS,
1650: cst_item_list_temp ITEMS,
1651: cst_cg_list_temp CGS,
1652: mtl_parameters MP,
1653: mtl_interorg_parameters MIP,
1654: mtl_material_transactions MMT,
1655: rcv_shipment_lines RSL,
1656: mtl_system_items MSI_FROM
1657: WHERE MS.from_organization_id = p_organization_id
1754: RSL.shipment_line_id
1755: FROM mtl_material_transactions MMT,
1756: cst_item_list_temp ITEMS,
1757: cst_cg_list_temp CGS,
1758: mtl_interorg_parameters MIP,
1759: mtl_system_items MSI_TO,
1760: rcv_shipment_headers RSH,
1761: rcv_shipment_lines RSL
1762: WHERE MMT.organization_id = p_organization_id
1854: RT.shipment_line_id
1855: FROM mtl_material_transactions MMT,
1856: cst_item_list_temp ITEMS,
1857: cst_cg_list_temp CGS,
1858: mtl_interorg_parameters MIP,
1859: mtl_system_items MSI_FROM,
1860: rcv_transactions RT
1861: WHERE MMT.transfer_organization_id = p_organization_id
1862: AND MMT.transaction_action_id = 12
1955: RSL.shipment_line_id
1956: FROM mtl_material_transactions MMT,
1957: cst_item_list_temp ITEMS,
1958: cst_cg_list_temp CGS,
1959: mtl_interorg_parameters MIP,
1960: mtl_system_items MSI_TO,
1961: rcv_shipment_headers RSH,
1962: rcv_shipment_lines RSL
1963: WHERE MMT.organization_id = p_organization_id
2056: RT.shipment_line_id
2057: FROM mtl_material_transactions MMT,
2058: cst_item_list_temp ITEMS,
2059: cst_cg_list_temp CGS,
2060: mtl_interorg_parameters MIP,
2061: mtl_system_items MSI_FROM,
2062: rcv_transactions RT
2063: WHERE MMT.transfer_organization_id = p_organization_id
2064: AND MMT.transaction_action_id = 12
2161: FROM mtl_supply MS,
2162: cst_item_list_temp ITEMS,
2163: cst_cg_list_temp CGS,
2164: mtl_parameters MP,
2165: mtl_interorg_parameters MIP,
2166: mtl_material_transactions MMT,
2167: rcv_shipment_lines RSL,
2168: mtl_system_items MSI_FROM
2169: WHERE MS.to_organization_id = p_organization_id
2258: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2259: FROM mtl_material_transactions MMT,
2260: cst_item_list_temp ITEMS,
2261: cst_cg_list_temp CGS,
2262: mtl_interorg_parameters MIP,
2263: mtl_system_items MSI_TO
2264: WHERE MMT.transfer_organization_id = p_organization_id
2265: AND MMT.transaction_action_id = 21
2266: AND MMT.costed_flag IN ('N','E')
2346: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2347: FROM mtl_material_transactions MMT,
2348: cst_item_list_temp ITEMS,
2349: cst_cg_list_temp CGS,
2350: mtl_interorg_parameters MIP,
2351: mtl_system_items MSI_FROM
2352: WHERE MMT.organization_id = p_organization_id
2353: AND MMT.transaction_action_id = 12
2354: AND MMT.costed_flag IN ('N', 'E')
2442: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2443: FROM mtl_material_transactions MMT,
2444: cst_item_list_temp ITEMS,
2445: cst_cg_list_temp CGS,
2446: mtl_interorg_parameters MIP,
2447: mtl_system_items MSI_TO,
2448: mtl_transaction_types MTT
2449: WHERE MMT.transfer_organization_id = p_organization_id
2450: AND MMT.transaction_action_id = 21
2539: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2540: FROM mtl_material_transactions MMT,
2541: cst_item_list_temp ITEMS,
2542: cst_cg_list_temp CGS,
2543: mtl_interorg_parameters MIP,
2544: mtl_system_items MSI_FROM,
2545: mtl_transaction_types MTT
2546: WHERE MMT.organization_id = p_organization_id
2547: AND MMT.transaction_action_id = 12
2638: FROM mtl_supply MS,
2639: cst_item_list_temp ITEMS,
2640: cst_cg_list_temp CGS,
2641: mtl_parameters MP,
2642: mtl_interorg_parameters MIP,
2643: mtl_material_transactions MMT,
2644: rcv_shipment_lines RSL,
2645: mtl_system_items MSI_FROM
2646: WHERE MS.from_organization_id = p_organization_id
2738: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2739: FROM mtl_material_transactions MMT,
2740: cst_item_list_temp ITEMS,
2741: cst_cg_list_temp CGS,
2742: mtl_interorg_parameters MIP,
2743: mtl_system_items MSI_TO
2744: WHERE MMT.organization_id = p_organization_id
2745: AND MMT.transaction_action_id = 21
2746: AND MMT.costed_flag IN ('N','E')
2830: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2831: FROM mtl_material_transactions MMT,
2832: cst_item_list_temp ITEMS,
2833: cst_cg_list_temp CGS,
2834: mtl_interorg_parameters MIP,
2835: mtl_system_items MSI_FROM
2836: WHERE MMT.transfer_organization_id = p_organization_id
2837: AND MMT.transaction_action_id = 12
2838: AND MMT.costed_flag IN ('N', 'E')
2926: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2927: FROM mtl_material_transactions MMT,
2928: cst_item_list_temp ITEMS,
2929: cst_cg_list_temp CGS,
2930: mtl_interorg_parameters MIP,
2931: mtl_system_items MSI_TO,
2932: mtl_transaction_types MTT
2933: WHERE MMT.organization_id = p_organization_id
2934: AND MMT.transaction_action_id = 21
3023: NVL(MMT.intransit_account, MIP.intransit_inv_account)
3024: FROM mtl_material_transactions MMT,
3025: cst_item_list_temp ITEMS,
3026: cst_cg_list_temp CGS,
3027: mtl_interorg_parameters MIP,
3028: mtl_system_items MSI_FROM,
3029: mtl_transaction_types MTT
3030: WHERE MMT.transfer_organization_id = p_organization_id
3031: AND MMT.transaction_action_id = 12
4283: MMT.transfer_organization_id,
4284: MMT.inventory_item_id,
4285: MMT.transfer_cost_group_id
4286: FROM mtl_material_transactions MMT,
4287: mtl_interorg_parameters MIP
4288: WHERE MMT.transaction_action_id = 21
4289: AND MIP.from_organization_id = MMT.organization_id
4290: AND MIP.to_organization_id = MMT.transfer_organization_id
4291: AND NVL(MMT.fob_point,MIP.fob_point)=1
4297: MMT.inventory_item_id,
4298: MMT.transfer_cost_group_id
4299: ) MINDATE,
4300: mtl_material_transactions MMT,
4301: mtl_interorg_parameters MIP
4302: WHERE MMT.transfer_organization_id = MINDATE.transfer_organization_id
4303: AND MMT.inventory_item_id = MINDATE.inventory_item_id
4304: AND MMT.transfer_cost_group_id = MINDATE.transfer_cost_group_id
4305: AND MMT.transaction_date = MINDATE.transaction_date