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.OZF_CLAIM_PUB dependencies on OZF_CLAIM_LINES_ALL

Line 1128: FROM ozf_claim_lines_all

1124: ,buy_group_party_id
1125: ,acctd_tax_amount
1126: ,dpp_cust_account_id
1127: ,batch_line_id
1128: FROM ozf_claim_lines_all
1129: WHERE claim_line_id = cv_claim_line_id;
1130:
1131: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1132: SELECT inventory_item_id,NVL(description,concatenated_segments)

Line 2914: FROM ozf_claim_lines_all

2910:
2911: CURSOR claim_lines_cur(cv_parent_claim_id IN NUMBER
2912: ,cv_claim_line_id IN NUMBER)IS
2913: SELECT claim_line_id,amount
2914: FROM ozf_claim_lines_all
2915: WHERE claim_id = cv_parent_claim_id
2916: AND claim_line_id = cv_claim_line_id;
2917: BEGIN
2918: -- Standard Start of API savepoint

Line 3244: ozf_claim_lines_all cli

3240:
3241: CURSOR csr_is_promo_claim(cv_claim_id IN NUMBER)IS
3242: SELECT COUNT(clu.claim_line_util_id)
3243: FROM ozf_claim_lines_util_all clu,
3244: ozf_claim_lines_all cli
3245: WHERE clu.claim_line_id = cli.claim_line_id
3246: AND cli.claim_id = cv_claim_id;
3247:
3248: CURSOR csr_claim_dup_chk(cv_claim_id IN NUMBER)IS