DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3963: , mtl_system_items msi

3959: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
3960: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
3961: FROM
3962: CST_PAC_INTERORG_TXNS_TMP ccit
3963: , mtl_system_items msi
3964: , mtl_secondary_inventories msubinv
3965: WHERE ccit.inventory_item_id = c_inventory_item_id
3966: AND ccit.cost_group_id = c_cost_group_id
3967: AND ccit.pac_period_id = c_period_id

Line 4455: , mtl_system_items msi

4451: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
4452: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
4453: FROM
4454: CST_PAC_INTERORG_TXNS_TMP ccit
4455: , mtl_system_items msi
4456: , mtl_secondary_inventories msubinv
4457: WHERE ccit.inventory_item_id = c_inventory_item_id
4458: AND ccit.cost_group_id = c_cost_group_id
4459: AND ccit.pac_period_id = c_period_id

Line 4917: , mtl_system_items msi

4913: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
4914: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
4915: FROM
4916: CST_PAC_INTERORG_TXNS_TMP ccit
4917: , mtl_system_items msi
4918: , mtl_secondary_inventories msubinv
4919: WHERE ccit.inventory_item_id = c_inventory_item_id
4920: AND ccit.cost_group_id = c_cost_group_id
4921: AND ccit.pac_period_id = c_period_id