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 2105: FROM dual

2101: 0,
2102: l_item_balance,
2103: 0,
2104: 0
2105: FROM dual
2106: WHERE NOT EXISTS (SELECT 1
2107: FROM cst_pac_item_cost_details cpicd1
2108: WHERE cpicd1.cost_layer_id = mpacd_idx.cost_layer_id
2109: AND cpicd1.cost_element_id = mpacd_idx.cost_element_id

Line 3479: from dual)

3475: and ccit.txn_type = 2)
3476: then 2
3477: else 3
3478: end) SEQUENCE_NUM
3479: from dual)
3480: where cpiit.cost_group_id = p_cost_group_id
3481: AND cpiit.pac_period_id = p_period_id
3482: AND cpiit.INTERORG_RECEIPT_FLAG = 'Y';
3483:

Line 4001: (SELECT 1 level_type FROM DUAL

3997: AND pac_period_id = p_period_id
3998: AND cost_type_id = p_cost_type_id
3999: AND rownum = 1) mpacd,
4000: CST_COST_ELEMENTS cce,
4001: (SELECT 1 level_type FROM DUAL
4002: UNION
4003: SELECT 2 level_type FROM DUAL) lt
4004: WHERE NOT EXISTS
4005: (SELECT 1

Line 4003: SELECT 2 level_type FROM DUAL) lt

3999: AND rownum = 1) mpacd,
4000: CST_COST_ELEMENTS cce,
4001: (SELECT 1 level_type FROM DUAL
4002: UNION
4003: SELECT 2 level_type FROM DUAL) lt
4004: WHERE NOT EXISTS
4005: (SELECT 1
4006: FROM mtl_pac_act_cst_dtl_temp mpacdt
4007: WHERE mpacdt.cost_group_id = p_cost_group_id

Line 4470: (SELECT 1 level_type FROM DUAL

4466: AND pac_period_id = p_period_id
4467: AND cost_type_id = p_cost_type_id
4468: AND rownum = 1) mpacd,
4469: CST_COST_ELEMENTS cce,
4470: (SELECT 1 level_type FROM DUAL
4471: UNION
4472: SELECT 2 level_type FROM DUAL) lt
4473: WHERE NOT EXISTS
4474: (SELECT 1

Line 4472: SELECT 2 level_type FROM DUAL) lt

4468: AND rownum = 1) mpacd,
4469: CST_COST_ELEMENTS cce,
4470: (SELECT 1 level_type FROM DUAL
4471: UNION
4472: SELECT 2 level_type FROM DUAL) lt
4473: WHERE NOT EXISTS
4474: (SELECT 1
4475: FROM mtl_pac_act_cst_dtl_temp mpacdt
4476: WHERE mpacdt.cost_group_id = p_cost_group_id

Line 5317: from dual)

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