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 DUAL

Line 2239: FROM dual

2235: 0,
2236: l_item_balance,
2237: 0,
2238: 0
2239: FROM dual
2240: WHERE NOT EXISTS (SELECT 1
2241: FROM cst_pac_item_cost_details cpicd1
2242: WHERE cpicd1.cost_layer_id = mpacd_idx.cost_layer_id
2243: AND cpicd1.cost_element_id = mpacd_idx.cost_element_id

Line 3635: from dual)

3631: and ccit.txn_type = 2)
3632: then 2
3633: else 3
3634: end) SEQUENCE_NUM
3635: from dual)
3636: where cpiit.cost_group_id = p_cost_group_id
3637: AND cpiit.pac_period_id = p_period_id
3638: AND cpiit.INTERORG_RECEIPT_FLAG = 'Y';
3639:

Line 4234: (SELECT 1 level_type FROM DUAL

4230: AND pac_period_id = p_period_id
4231: AND cost_type_id = p_cost_type_id
4232: AND rownum = 1) mpacd,
4233: CST_COST_ELEMENTS cce,
4234: (SELECT 1 level_type FROM DUAL
4235: UNION
4236: SELECT 2 level_type FROM DUAL) lt
4237: WHERE NOT EXISTS
4238: (SELECT 1

Line 4236: SELECT 2 level_type FROM DUAL) lt

4232: AND rownum = 1) mpacd,
4233: CST_COST_ELEMENTS cce,
4234: (SELECT 1 level_type FROM DUAL
4235: UNION
4236: SELECT 2 level_type FROM DUAL) lt
4237: WHERE NOT EXISTS
4238: (SELECT 1
4239: FROM mtl_pac_act_cst_dtl_temp mpacdt
4240: WHERE mpacdt.cost_group_id = p_cost_group_id

Line 4703: (SELECT 1 level_type FROM DUAL

4699: AND pac_period_id = p_period_id
4700: AND cost_type_id = p_cost_type_id
4701: AND rownum = 1) mpacd,
4702: CST_COST_ELEMENTS cce,
4703: (SELECT 1 level_type FROM DUAL
4704: UNION
4705: SELECT 2 level_type FROM DUAL) lt
4706: WHERE NOT EXISTS
4707: (SELECT 1

Line 4705: SELECT 2 level_type FROM DUAL) lt

4701: AND rownum = 1) mpacd,
4702: CST_COST_ELEMENTS cce,
4703: (SELECT 1 level_type FROM DUAL
4704: UNION
4705: SELECT 2 level_type FROM DUAL) lt
4706: WHERE NOT EXISTS
4707: (SELECT 1
4708: FROM mtl_pac_act_cst_dtl_temp mpacdt
4709: WHERE mpacdt.cost_group_id = p_cost_group_id

Line 5592: from dual)

5588: WHEN 4 THEN G_PWAC_NEW_COST_TBL(4)(2).final_new_cost
5589: WHEN 5 THEN G_PWAC_NEW_COST_TBL(5)(2).final_new_cost
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