[Home] [Help]
431: fnd_global.conc_login_id
432: From CSP_PLANNING_PARAMETERS cpp,
433: MTL_ITEM_SUB_INVENTORIES mis,
434: CST_ITEM_COSTS cic,
435: MTL_PARAMETERS mp
436: where cpp.node_type = 'SUBINVENTORY'
437: and mis.organization_id = cpp.organization_id
438: and mis.secondary_inventory = cpp.secondary_inventory
439: and mp.organization_id = cpp.organization_id
488: fnd_global.conc_login_id
489: From CSP_PLANNING_PARAMETERS cpp,
490: MTL_SYSTEM_ITEMS msi,
491: CST_ITEM_COSTS cic,
492: MTL_PARAMETERS mp
493: where cpp.node_type = 'ORGANIZATION_WH'
494: and mp.organization_id = cpp.organization_id
495: and msi.organization_id = cpp.organization_id
496: and msi.inventory_planning_code = 2
565: fnd_global.conc_login_id
566: from csp_planning_parameters cpp,
567: csp_usage_headers cuh,
568: cst_item_costs cic,
569: mtl_parameters mp,
570: mtl_system_items_b msib,
571: mtl_item_sub_inventories misi,
572: mtl_secondary_inventories msi,
573: mtl_interorg_ship_methods mism1,
2186: fnd_global.user_id,
2187: sysdate
2188: from csp_region_items_v cri,
2189: mtl_related_items mri,
2190: mtl_parameters mp,
2191: mtl_system_items_b msib,
2192: mtl_item_sub_inventories misi,
2193: mtl_secondary_inventories msi
2194: where cri.level_id like l_level_id || '%'
2236: sysdate,
2237: fnd_global.user_id,
2238: fnd_global.user_id,
2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,
2242: mtl_item_sub_inventories misi,
2243: mtl_secondary_inventories msi,
2244: csp_supply_chain csc
2414: sysdate,
2415: fnd_global.user_id,
2416: fnd_global.user_id,
2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,
2421: mtl_secondary_inventories msi,
2422: mtl_material_transactions mmt,
2480: sysdate,
2481: fnd_global.user_id,
2482: fnd_global.user_id,
2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,
2486: mtl_item_sub_inventories misi,
2487: mtl_secondary_inventories msi,
2488: csp_supply_chain csc,