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.CN_SCA_CREDITS_ONLINE_PUB dependencies on CN_SCA_ALLOCATIONS

Line 86: cn_sca_allocations csa

82: FROM cn_sca_headers_interface_gtt cshi,
83: cn_sca_winning_rules_gtt w,
84: cn_sca_lines_output_gtt l,
85: cn_sca_alloc_details csad,
86: cn_sca_allocations csa
87: WHERE cshi.sca_headers_interface_id = w.sca_headers_interface_id
88: AND w.sca_headers_interface_id = l.sca_headers_interface_id
89: AND w.sca_credit_rule_id = csa.sca_credit_rule_id
90: AND csad.sca_allocation_id = csa.sca_allocation_id

Line 106: cn_sca_allocations csa

102: FROM cn_sca_headers_interface_gtt cshi,
103: cn_sca_winning_rules_gtt w,
104: cn_sca_lines_output_gtt l,
105: cn_sca_alloc_details csad,
106: cn_sca_allocations csa
107: WHERE cshi.sca_headers_interface_id = w.sca_headers_interface_id
108: AND w.sca_headers_interface_id = l.sca_headers_interface_id
109: AND w.sca_credit_rule_id = csa.sca_credit_rule_id
110: AND csad.sca_allocation_id = csa.sca_allocation_id

Line 239: cn_sca_allocations csa,

235: DECODE(csad.nrev_credit_split,''Y'',
236: ROUND(csad.nonrev_split_pct/NVL(crc.count_of_resources,1),4),
237: csad.nonrev_split_pct) non_rev_value
238: FROM cn_sca_alloc_details csad,
239: cn_sca_allocations csa,
240: (SELECT min( sca_credit_rule_id) sca_credit_rule_id,
241: sca_headers_interface_id
242: FROM cn_sca_winning_rules_gtt
243: WHERE sca_batch_id = :x_batch_id2