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.CSTPPWAC dependencies on DUAL

Line 3643: FROM dual) temp

3639: CSTPPINV.l_level_type_tbl(l_index) level_type,
3640: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3641: l_category_qty_tbl (l_index) category_quantity,
3642: CSTPPINV.l_item_balance_tbl(l_index) category_balance
3643: FROM dual) temp
3644: ON ( cppb.pac_period_id = temp.pac_period_id
3645: AND cppb.cost_layer_id = temp.cost_layer_id
3646: AND cppb.cost_element_id = temp.cost_element_id
3647: AND cppb.level_type = temp.level_type

Line 3784: FROM dual

3780: 0,
3781: CSTPPINV.l_item_balance_tbl (l_index),
3782: CSTPPINV.l_make_balance_tbl (l_index),
3783: CSTPPINV.l_buy_balance_tbl (l_index)
3784: FROM dual
3785: WHERE NOT EXISTS (SELECT 1
3786: FROM cst_pac_item_cost_details cpicd1
3787: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3788: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)

Line 3829: FROM sys.dual)

3825: i_prog_appl_id,
3826: i_prog_id,
3827: sysdate,
3828: l_new_qty_tbl (l_index)
3829: FROM sys.dual)
3830: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3831: AND EXISTS
3832: (SELECT 'there is a layer'
3833: FROM cst_pac_quantity_layers cpql