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 260: FROM ozf_claim_lines

256:
257: --// Bug 10241971
258: CURSOR csr_get_inv_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
259: SELECT source_object_id, SUM(NVL(claim_currency_amount,0))
260: FROM ozf_claim_lines
261: WHERE claim_id = cv_claim_id
262: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
263: GROUP BY source_object_id;
264:

Line 268: FROM ozf_claim_lines

264:
265: /*
266: CURSOR csr_get_inv_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
267: SELECT source_object_id, SUM(NVL(claim_currency_amount,0))
268: FROM ozf_claim_lines
269: WHERE claim_id = cv_claim_id
270: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
271: GROUP BY source_object_id;
272: */

Line 278: FROM ozf_claim_lines

274: CURSOR csr_get_creditto_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
275: SELECT source_object_id
276: , credit_to
277: , SUM(NVL(claim_currency_amount,0))
278: FROM ozf_claim_lines
279: WHERE claim_id = cv_claim_id
280: AND source_object_class IN ('INVOICE', 'DM', 'CB')
281: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
282: GROUP BY source_object_id, credit_to;

Line 288: FROM ozf_claim_lines

284: CURSOR csr_get_lineid_info(cv_claim_id IN NUMBER, cv_invoice_id IN NUMBER) IS
285: SELECT source_object_id
286: , source_object_line_id
287: , SUM(NVL(claim_currency_amount,0))
288: FROM ozf_claim_lines
289: WHERE claim_id = cv_claim_id
290: AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
291: GROUP BY source_object_id,source_object_line_id;
292:

Line 446: FROM ozf_claim_lines

442: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
443:
444: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
445: SELECT NVL(SUM(claim_currency_amount), 0)
446: FROM ozf_claim_lines
447: WHERE claim_id = cv_claim_id;
448:
449: CURSOR csr_sysparam_defaults(cv_set_of_books_id IN NUMBER) IS
450: SELECT batch_source_id

Line 501: FROM ozf_claim_lines

497: SELECT item_id
498: , quantity_uom
499: --, org_id
500: , FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID')
501: FROM ozf_claim_lines
502: WHERE item_type = 'PRODUCT'
503: AND claim_id = cv_claim_id;
504:
505: CURSOR csr_validate_primary_uom( cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS

Line 522: FROM ozf_claim_lines

518: FROM ar_system_parameters;
519:
520: CURSOR csr_get_inv_info(cv_claim_id IN NUMBER) IS
521: SELECT source_object_id, source_object_class, SUM(NVL(claim_currency_amount,0))
522: FROM ozf_claim_lines
523: WHERE claim_id = cv_claim_id
524: GROUP BY source_object_id, source_object_class;
525:
526: l_object_class VARCHAR2(15);