[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,
2166: fnd_global.user_id,
2167: sysdate
2168: from csp_region_items_v cri,
2169: mtl_related_items mri,
2170: mtl_parameters mp,
2171: mtl_system_items_b msib,
2172: mtl_item_sub_inventories misi,
2173: mtl_secondary_inventories msi
2174: where cri.level_id like l_level_id || '%'
2216: sysdate,
2217: fnd_global.user_id,
2218: fnd_global.user_id,
2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,
2222: mtl_item_sub_inventories misi,
2223: mtl_secondary_inventories msi,
2224: csp_supply_chain csc
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.user_id,
2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,
2401: mtl_secondary_inventories msi,
2402: mtl_material_transactions mmt,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.user_id,
2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,
2466: mtl_item_sub_inventories misi,
2467: mtl_secondary_inventories msi,
2468: csp_supply_chain csc,