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 891: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit

887: , ccit.transfer_transaction_id transfer_transaction_id
888: , ccit.cost_group_id cost_group_id
889: , ccit.txn_type txn_type
890: FROM
891: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit
892: WHERE ccit.inventory_item_id = c_inventory_item_id
893: AND ccit.pac_period_id = c_period_id
894: AND cpiit.inventory_item_id = ccit.inventory_item_id
895: AND cpiit.cost_group_id = ccit.cost_group_id

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

2851: , l_routine || '<'
2852: );
2853: END IF;
2854:
2855: DELETE FROM CST_PAC_INTERORG_TXNS_TMP WHERE COST_GROUP_ID = p_cost_group_id AND PAC_PERIOD_ID = p_period_id;
2856:
2857: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
2858: l_txn_type := 1;
2859:

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

2853: END IF;
2854:
2855: DELETE FROM CST_PAC_INTERORG_TXNS_TMP WHERE COST_GROUP_ID = p_cost_group_id AND PAC_PERIOD_ID = p_period_id;
2856:
2857: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
2858: l_txn_type := 1;
2859:
2860: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
2861: ( transaction_id,

Line 2860: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

2856:
2857: --Cost owned across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
2858: l_txn_type := 1;
2859:
2860: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
2861: ( transaction_id,
2862: transaction_action_id,
2863: transaction_source_type_id,
2864: inventory_item_id,

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

3017: AND ccga3.cost_group_id = p_cost_group_id))
3018: ));
3019:
3020:
3021: --Cost derived across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3022:
3023: l_txn_type := 2;
3024:
3025: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

Line 3025: INSERT INTO CST_PAC_INTERORG_TXNS_TMP

3021: --Cost derived across CG interorg transactions for this cost group being populated in CST_PAC_INTERORG_TXNS_TMP
3022:
3023: l_txn_type := 2;
3024:
3025: INSERT INTO CST_PAC_INTERORG_TXNS_TMP
3026: ( transaction_id,
3027: transaction_action_id,
3028: transaction_source_type_id,
3029: inventory_item_id,

Line 3313: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp

3309: , 0
3310: , 0
3311: , 'N'
3312: , 'Y'
3313: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp
3314: WHERE ccit.cost_group_id = p_cost_group_id
3315: AND ccit.pac_period_id = p_period_id
3316: AND ccit.txn_type = 1
3317: AND mp.organization_id = ccit.transfer_organization_id

Line 3358: FROM CST_PAC_INTERORG_TXNS_TMP ccit

3354: , 'N'
3355: , 'N'
3356: , 'Y'
3357: , 1
3358: FROM CST_PAC_INTERORG_TXNS_TMP ccit
3359: WHERE ccit.cost_group_id = p_cost_group_id
3360: AND ccit.pac_period_id = p_period_id
3361: AND ccit.txn_type = 2
3362: AND NOT EXISTS (

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

3401: , 0
3402: , 0
3403: , 'N'
3404: , 'Y'
3405: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3406: WHERE ccit.cost_group_id = p_cost_group_id
3407: AND ccit.pac_period_id = p_period_id
3408: AND ccit.txn_type = 1
3409: AND mp.organization_id = ccit.transfer_organization_id

Line 3444: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc

3440: , 'N'
3441: , 'N'
3442: , 'Y'
3443: , 1
3444: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc
3445: WHERE ccit.cost_group_id = p_cost_group_id
3446: AND ccit.pac_period_id = p_period_id
3447: AND ccit.txn_type = 2
3448: AND cpllc.inventory_item_id = ccit.inventory_item_id

Line 3462: from CST_PAC_INTERORG_TXNS_TMP ccit

3458:
3459: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3460: SET (INTERORG_SHIPMENT_FLAG,
3461: SEQUENCE_NUM) = (select (case when exists(select 'X'
3462: from CST_PAC_INTERORG_TXNS_TMP ccit
3463: where ccit.pac_period_id = p_period_id
3464: and ccit.cost_group_id = p_cost_group_id
3465: and ccit.inventory_item_id = cpiit.inventory_item_id
3466: and ccit.txn_type = 2)

Line 3471: from CST_PAC_INTERORG_TXNS_TMP ccit

3467: then 'Y'
3468: else 'N'
3469: end) INTERORG_SHIPMENT_FLAG,
3470: (case when exists(select 'X'
3471: from CST_PAC_INTERORG_TXNS_TMP ccit
3472: where ccit.pac_period_id = p_period_id
3473: and ccit.cost_group_id = p_cost_group_id
3474: and ccit.inventory_item_id = cpiit.inventory_item_id
3475: and ccit.txn_type = 2)

Line 3729: CST_PAC_INTERORG_TXNS_TMP ccit

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

Line 4221: CST_PAC_INTERORG_TXNS_TMP ccit

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

Line 4683: CST_PAC_INTERORG_TXNS_TMP ccit

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

Line 5319: FROM CST_PAC_INTERORG_TXNS_TMP ccit

5315: END)
5316: END) actual_cost
5317: from dual)
5318: where mpacdt.transaction_id in (select ccit.transaction_id
5319: FROM CST_PAC_INTERORG_TXNS_TMP ccit
5320: WHERE ccit.inventory_item_id = p_inventory_item_id
5321: AND ccit.cost_group_id = p_cost_group_id
5322: AND ccit.pac_period_id = p_period_id
5323: AND ccit.txn_type = 2)