APPS.OZF_AR_VALIDATION_PVT dependencies on OZF_CLAIM_LINES

Line 42: FROM ozf_claim_lines

38: , credit_to
39: , SUM(quantity) qty
40: , AVG(rate) rate
41: , SUM(NVL(claim_currency_amount,0)) amount
42: FROM ozf_claim_lines
43: WHERE claim_id = cv_claim_id
44: GROUP BY source_object_id, source_object_line_id, credit_to;
45: l_trx_lines csr_claim_line_invoice%ROWTYPE;
46:

Line 254: FROM ozf_claim_lines

250:
251:
252: CURSOR csr_get_inv_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
253: SELECT source_object_id, SUM(NVL(claim_currency_amount,0))
254: FROM ozf_claim_lines
255: WHERE claim_id = cv_claim_id
256: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
257: GROUP BY source_object_id;
258:

Line 263: FROM ozf_claim_lines

259: CURSOR csr_get_creditto_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
260: SELECT source_object_id
261: , credit_to
262: , SUM(NVL(claim_currency_amount,0))
263: FROM ozf_claim_lines
264: WHERE claim_id = cv_claim_id
265: AND source_object_class IN ('INVOICE', 'DM', 'CB')
266: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
267: GROUP BY source_object_id, credit_to;

Line 273: FROM ozf_claim_lines

269: CURSOR csr_get_lineid_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
270: SELECT source_object_id
271: , source_object_line_id
272: , SUM(NVL(claim_currency_amount,0))
273: FROM ozf_claim_lines
274: WHERE claim_id = cv_claim_id
275: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
276: GROUP BY source_object_id,source_object_line_id;
277:

Line 431: FROM ozf_claim_lines

427: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
428:
429: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
430: SELECT NVL(SUM(claim_currency_amount), 0)
431: FROM ozf_claim_lines
432: WHERE claim_id = cv_claim_id;
433:
434: CURSOR csr_sysparam_defaults(cv_set_of_books_id IN NUMBER) IS
435: SELECT batch_source_id

Line 486: FROM ozf_claim_lines

482: SELECT item_id
483: , quantity_uom
484: --, org_id
485: , FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID')
486: FROM ozf_claim_lines
487: WHERE item_type = 'PRODUCT'
488: AND claim_id = cv_claim_id;
489:
490: CURSOR csr_validate_primary_uom( cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS

Line 507: FROM ozf_claim_lines

503: FROM ar_system_parameters;
504:
505: CURSOR csr_get_inv_info(cv_claim_id IN NUMBER) IS
506: SELECT source_object_id, source_object_class, SUM(NVL(claim_currency_amount,0))
507: FROM ozf_claim_lines
508: WHERE claim_id = cv_claim_id
509: GROUP BY source_object_id, source_object_class;
510:
511: l_object_class VARCHAR2(15);