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_ACCRUAL_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 8690: , ozf_sd_batch_lines_all line

8686: SELECT util.utilization_id
8687: , line.batch_curr_claim_amount
8688: , offr.transaction_currency_code
8689: FROM ozf_funds_utilized_all_b util
8690: , ozf_sd_batch_lines_all line
8691: , ozf_offers offr
8692: WHERE util.utilization_id = line.utilization_id
8693: AND util.plan_id = offr.qp_list_header_id
8694: AND line.batch_id = cv_batch_id

Line 8713: , ozf_sd_batch_lines_all line

8709: , util.exchange_rate_date
8710: , util.exchange_rate_type
8711: , line.batch_curr_claim_amount
8712: FROM ozf_funds_utilized_all_b util
8713: , ozf_sd_batch_lines_all line
8714: WHERE util.utilization_id = line.utilization_id
8715: AND line.status_code ='APPROVED' --//Bugfix: 9794989
8716: AND line.purge_flag ='N'
8717: AND line.batch_id = cv_batch_id

Line 11961: FROM ozf_sd_batch_lines_all

11957: CURSOR csr_batch_uom_code ( cv_batch_id IN NUMBER
11958: , cv_product_id IN NUMBER
11959: ) IS
11960: SELECT shipped_quantity_uom
11961: FROM ozf_sd_batch_lines_all
11962: WHERE batch_id = cv_batch_id
11963: AND item_id = cv_product_id;
11964:
11965: --Bugfix:7169388

Line 12071: , ozf_sd_batch_lines_all line

12067: , util.bill_to_site_use_id
12068: , head.claim_number
12069: FROM ozf_funds_utilized_all_b util
12070: , ozf_sd_batch_headers_all head
12071: , ozf_sd_batch_lines_all line
12072: WHERE head.batch_id = cv_batch_id
12073: AND head.batch_id = line.batch_id
12074: --Fix for Bug 10047209
12075: --AND line.status_code ='APPROVED' --//Bugfix: 9794989

Line 12090: , ozf_sd_batch_lines_all line

12086: , util.product_level_type
12087: , util.product_id
12088: , sum(line.batch_curr_claim_amount)
12089: FROM ozf_funds_utilized_all_b util
12090: , ozf_sd_batch_lines_all line
12091: WHERE line.batch_id = cv_batch_id
12092: --Fix for Bug 10047209
12093: --AND line.status_code ='APPROVED' --//Bugfix: 9794989
12094: AND line.purge_flag ='N'

Line 12118: , ozf_sd_batch_lines_all line

12114: , util.product_id
12115: , line.batch_curr_claim_amount
12116: , line.batch_line_id
12117: FROM ozf_funds_utilized_all_b util
12118: , ozf_sd_batch_lines_all line
12119: WHERE line.batch_id = cv_batch_id
12120: --Fix for Bug 10047209
12121: -- AND line.status_code ='APPROVED' --//Bugfix: 9794989
12122: AND line.purge_flag ='N'