APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2609: from ra_customer_trx_lines_all cm

2605: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calculate cm tax amount.');
2606: END IF;
2607: select cm.extended_amount, cm.quantity_credited
2608: into cm_line_amount, cm_line_qty
2609: from ra_customer_trx_lines_all cm
2610: where cm.customer_trx_line_id = tax_info_rec.customer_trx_line_id;
2611:
2612: select line.extended_amount,
2613: tax.extended_amount,

Line 2618: from ra_customer_trx_lines_all line,

2614: line.quantity_invoiced
2615: into orig_line_amount,
2616: orig_tax_amount,
2617: orig_line_qty
2618: from ra_customer_trx_lines_all line,
2619: ra_customer_trx_lines_all tax
2620: where tax.customer_trx_line_id = prev_ctlid
2621: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2622:

Line 2619: ra_customer_trx_lines_all tax

2615: into orig_line_amount,
2616: orig_tax_amount,
2617: orig_line_qty
2618: from ra_customer_trx_lines_all line,
2619: ra_customer_trx_lines_all tax
2620: where tax.customer_trx_line_id = prev_ctlid
2621: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2622:
2623:

Line 2676: from ra_customer_trx_lines_all line,

2672: --BugFix 2499050 Modified the expression in the following DECODE statement.
2673: cursor l_extended_amount_csr is
2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =

Line 2677: ra_customer_trx_lines_all prev_line,

2673: cursor l_extended_amount_csr is
2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2681: tax_no_vendor

Line 2678: ra_customer_trx_lines_all prev_tax

2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2681: tax_no_vendor
2682: and prev_tax.link_to_cust_trx_line_id = prev_line.customer_trx_line_id

Line 2751: ra_customer_trx_lines_all line

2747: into l_inv_trx_date
2748: from ra_customer_trx_all inv_trx,
2749: ra_cust_trx_types_all trx_type,
2750: ra_customer_trx_all trx,
2751: ra_customer_trx_lines_all line
2752: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2753: and trx_type.type = 'CM'
2754: and trx_type.org_id = trx.org_id
2755: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

Line 6446: ra_customer_trx_lines_all ratrxlines

6442: FROM
6443: zx_transaction_lines_gt Lines,
6444: --zx_trx_headers_gt Headers,
6445: zx_evnt_cls_mappings event,
6446: ra_customer_trx_lines_all ratrxlines
6447: WHERE
6448: lines.application_id = 222
6449: AND lines.application_id = event.application_id
6450: AND lines.entity_code = event.entity_code

Line 6482: ra_customer_trx_lines_all ratrxlines

6478: FROM
6479: zx_transaction_lines_gt Lines,
6480: --zx_trx_headers_gt Headers,
6481: zx_evnt_cls_mappings event,
6482: ra_customer_trx_lines_all ratrxlines
6483: WHERE
6484: lines.application_id = 222
6485: AND lines.application_id = event.application_id
6486: AND lines.entity_code = event.entity_code