APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 6866: , ozf_sd_batch_lines_all line

6862: SELECT util.utilization_id
6863: , line.batch_curr_claim_amount
6864: , offr.transaction_currency_code
6865: FROM ozf_funds_utilized_all_b util
6866: , ozf_sd_batch_lines_all line
6867: , ozf_offers offr
6868: WHERE util.utilization_id = line.utilization_id
6869: AND util.plan_id = offr.qp_list_header_id
6870: AND line.batch_id = cv_batch_id

Line 9702: FROM ozf_sd_batch_lines_all

9698: CURSOR csr_batch_uom_code ( cv_batch_id IN NUMBER
9699: , cv_product_id IN NUMBER
9700: ) IS
9701: SELECT shipped_quantity_uom
9702: FROM ozf_sd_batch_lines_all
9703: WHERE batch_id = cv_batch_id
9704: AND item_id = cv_product_id;
9705:
9706: --Bugfix:7169388

Line 9792: , ozf_sd_batch_lines_all line

9788: , util.bill_to_site_use_id
9789: , head.claim_number
9790: FROM ozf_funds_utilized_all_b util
9791: , ozf_sd_batch_headers_all head
9792: , ozf_sd_batch_lines_all line
9793: WHERE head.batch_id = cv_batch_id
9794: AND head.batch_id = line.batch_id
9795: AND util.utilization_id = line.utilization_id;
9796:

Line 9808: , ozf_sd_batch_lines_all line

9804: , util.product_level_type
9805: , util.product_id
9806: , sum(line.batch_curr_claim_amount)
9807: FROM ozf_funds_utilized_all_b util
9808: , ozf_sd_batch_lines_all line
9809: WHERE line.batch_id = cv_batch_id
9810: AND util.cust_account_id = cv_cust_account_id
9811: AND NVL(util.bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)
9812: AND util.utilization_id = line.utilization_id

Line 9833: , ozf_sd_batch_lines_all line

9829: , util.product_id
9830: , line.batch_curr_claim_amount
9831: , line.batch_line_id
9832: FROM ozf_funds_utilized_all_b util
9833: , ozf_sd_batch_lines_all line
9834: WHERE line.batch_id = cv_batch_id
9835: AND util.cust_account_id = cv_cust_account_id
9836: AND NVL(util.bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)
9837: AND util.utilization_id = line.utilization_id;