eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_INTERORG_TXNS_TMP

Line 897: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit

893: , ccit.transfer_transaction_id transfer_transaction_id
894: , ccit.cost_group_id cost_group_id
895: , ccit.txn_type txn_type
896: FROM
897: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit
898: WHERE ccit.inventory_item_id = c_inventory_item_id
899: AND ccit.pac_period_id = c_period_id
900: AND cpiit.inventory_item_id = ccit.inventory_item_id
901: AND cpiit.cost_group_id = ccit.cost_group_id

Line 2043: ,CST_PAC_INTERORG_TXNS_TMP cpitt

2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
2043: ,CST_PAC_INTERORG_TXNS_TMP cpitt
2044: WHERE mpacdt.pac_period_id = p_pac_period_id
2045: AND mpacdt.inventory_item_id = p_inventory_item_id
2046: AND mpacdt.cost_group_id = nvl(p_cost_group_id, mpacdt.cost_group_id)
2047: AND EXISTS (SELECT 'X'

Line 3001: DELETE FROM CST_PAC_INTERORG_TXNS_TMP WHERE COST_GROUP_ID = p_cost_group_id AND PAC_PERIOD_ID = p_period_id;

2997: , l_routine || '<'
2998: );
2999: END IF;
3000:
3001: DELETE FROM CST_PAC_INTERORG_TXNS_TMP WHERE COST_GROUP_ID = p_cost_group_id AND PAC_PERIOD_ID = p_period_id;
3002:
3003: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3004: l_txn_type := 1;
3005:

Line 3003: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP

2999: END IF;
3000:
3001: DELETE FROM CST_PAC_INTERORG_TXNS_TMP WHERE COST_GROUP_ID = p_cost_group_id AND PAC_PERIOD_ID = p_period_id;
3002:
3003: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3004: l_txn_type := 1;
3005:
3006: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
3007: ( transaction_id,

Line 3006: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

3002:
3003: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3004: l_txn_type := 1;
3005:
3006: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
3007: ( transaction_id,
3008: transaction_action_id,
3009: transaction_source_type_id,
3010: inventory_item_id,

Line 3177: --Cost derived across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP

3173: AND ccga3.cost_group_id = p_cost_group_id))
3174: ));
3175:
3176:
3177: --Cost derived across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3178:
3179: l_txn_type := 2;
3180:
3181: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

Line 3181: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

3177: --Cost derived across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3178:
3179: l_txn_type := 2;
3180:
3181: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
3182: ( transaction_id,
3183: transaction_action_id,
3184: transaction_source_type_id,
3185: inventory_item_id,

Line 3469: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp

3465: , 0
3466: , 0
3467: , 'N'
3468: , 'Y'
3469: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp
3470: WHERE ccit.cost_group_id = p_cost_group_id
3471: AND ccit.pac_period_id = p_period_id
3472: AND ccit.txn_type = 1
3473: AND mp.organization_id = ccit.transfer_organization_id

Line 3514: FROM CST_PAC_INTERORG_TXNS_TMP ccit

3510: , 'N'
3511: , 'N'
3512: , 'Y'
3513: , 1
3514: FROM CST_PAC_INTERORG_TXNS_TMP ccit
3515: WHERE ccit.cost_group_id = p_cost_group_id
3516: AND ccit.pac_period_id = p_period_id
3517: AND ccit.txn_type = 2
3518: AND NOT EXISTS (

Line 3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc

3557: , 0
3558: , 0
3559: , 'N'
3560: , 'Y'
3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3562: WHERE ccit.cost_group_id = p_cost_group_id
3563: AND ccit.pac_period_id = p_period_id
3564: AND ccit.txn_type = 1
3565: AND mp.organization_id = ccit.transfer_organization_id

Line 3600: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc

3596: , 'N'
3597: , 'N'
3598: , 'Y'
3599: , 1
3600: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc
3601: WHERE ccit.cost_group_id = p_cost_group_id
3602: AND ccit.pac_period_id = p_period_id
3603: AND ccit.txn_type = 2
3604: AND cpllc.inventory_item_id = ccit.inventory_item_id

Line 3618: from CST_PAC_INTERORG_TXNS_TMP ccit

3614:
3615: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3616: SET (INTERORG_SHIPMENT_FLAG,
3617: SEQUENCE_NUM) = (select (case when exists(select 'X'
3618: from CST_PAC_INTERORG_TXNS_TMP ccit
3619: where ccit.pac_period_id = p_period_id
3620: and ccit.cost_group_id = p_cost_group_id
3621: and ccit.inventory_item_id = cpiit.inventory_item_id
3622: and ccit.txn_type = 2)

Line 3627: from CST_PAC_INTERORG_TXNS_TMP ccit

3623: then 'Y'
3624: else 'N'
3625: end) INTERORG_SHIPMENT_FLAG,
3626: (case when exists(select 'X'
3627: from CST_PAC_INTERORG_TXNS_TMP ccit
3628: where ccit.pac_period_id = p_period_id
3629: and ccit.cost_group_id = p_cost_group_id
3630: and ccit.inventory_item_id = cpiit.inventory_item_id
3631: and ccit.txn_type = 2)

Line 3962: CST_PAC_INTERORG_TXNS_TMP ccit

3958: , nvl(ccit.transfer_percentage,0) transfer_percentage
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

Line 4454: CST_PAC_INTERORG_TXNS_TMP ccit

4450: , nvl(ccit.transfer_percentage,0) transfer_percentage
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

Line 4916: CST_PAC_INTERORG_TXNS_TMP ccit

4912: , nvl(ccit.transfer_percentage,0) transfer_percentage
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

Line 5594: FROM CST_PAC_INTERORG_TXNS_TMP ccit

5590: END)
5591: END) actual_cost
5592: from dual)
5593: where mpacdt.transaction_id in (select ccit.transaction_id
5594: FROM CST_PAC_INTERORG_TXNS_TMP ccit
5595: WHERE ccit.inventory_item_id = p_inventory_item_id
5596: AND ccit.cost_group_id = p_cost_group_id
5597: AND ccit.pac_period_id = p_period_id
5598: AND ccit.txn_type = 2)