DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3730: , mtl_system_items msi

3726: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
3727: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
3728: FROM
3729: CST_PAC_INTERORG_TXNS_TMP ccit
3730: , mtl_system_items msi
3731: , mtl_secondary_inventories msubinv
3732: WHERE ccit.inventory_item_id = c_inventory_item_id
3733: AND ccit.cost_group_id = c_cost_group_id
3734: AND ccit.pac_period_id = c_period_id

Line 4222: , mtl_system_items msi

4218: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
4219: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
4220: FROM
4221: CST_PAC_INTERORG_TXNS_TMP ccit
4222: , mtl_system_items msi
4223: , mtl_secondary_inventories msubinv
4224: WHERE ccit.inventory_item_id = c_inventory_item_id
4225: AND ccit.cost_group_id = c_cost_group_id
4226: AND ccit.pac_period_id = c_period_id

Line 4684: , mtl_system_items msi

4680: , DECODE(msi.inventory_asset_flag,'Y',0,1) exp_item
4681: , DECODE(msubinv.asset_inventory,1,0,1) exp_flag
4682: FROM
4683: CST_PAC_INTERORG_TXNS_TMP ccit
4684: , mtl_system_items msi
4685: , mtl_secondary_inventories msubinv
4686: WHERE ccit.inventory_item_id = c_inventory_item_id
4687: AND ccit.cost_group_id = c_cost_group_id
4688: AND ccit.pac_period_id = c_period_id