APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2290: from ra_customer_trx_lines_all cm

2286: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calculate cm tax amount.');
2287: END IF;
2288: select cm.extended_amount, cm.quantity_credited
2289: into cm_line_amount, cm_line_qty
2290: from ra_customer_trx_lines_all cm
2291: where cm.customer_trx_line_id = tax_info_rec.customer_trx_line_id;
2292:
2293: select line.extended_amount,
2294: tax.extended_amount,

Line 2299: from ra_customer_trx_lines_all line,

2295: line.quantity_invoiced
2296: into orig_line_amount,
2297: orig_tax_amount,
2298: orig_line_qty
2299: from ra_customer_trx_lines_all line,
2300: ra_customer_trx_lines_all tax
2301: where tax.customer_trx_line_id = prev_ctlid
2302: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2303:

Line 2300: ra_customer_trx_lines_all tax

2296: into orig_line_amount,
2297: orig_tax_amount,
2298: orig_line_qty
2299: from ra_customer_trx_lines_all line,
2300: ra_customer_trx_lines_all tax
2301: where tax.customer_trx_line_id = prev_ctlid
2302: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2303:
2304:

Line 2357: from ra_customer_trx_lines_all line,

2353: --BugFix 2499050 Modified the expression in the following DECODE statement.
2354: cursor l_extended_amount_csr is
2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =

Line 2358: ra_customer_trx_lines_all prev_line,

2354: cursor l_extended_amount_csr is
2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2362: tax_no_vendor

Line 2359: ra_customer_trx_lines_all prev_tax

2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2362: tax_no_vendor
2363: and prev_tax.link_to_cust_trx_line_id = prev_line.customer_trx_line_id

Line 2432: ra_customer_trx_lines_all line

2428: into l_inv_trx_date
2429: from ra_customer_trx_all inv_trx,
2430: ra_cust_trx_types_all trx_type,
2431: ra_customer_trx_all trx,
2432: ra_customer_trx_lines_all line
2433: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2434: and trx_type.type = 'CM'
2435: and trx_type.org_id = trx.org_id
2436: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

Line 6038: ra_customer_trx_lines_all ratrxlines

6034: FROM
6035: zx_transaction_lines_gt Lines,
6036: --zx_trx_headers_gt Headers,
6037: zx_evnt_cls_mappings event,
6038: ra_customer_trx_lines_all ratrxlines
6039: WHERE
6040: lines.application_id = 222
6041: AND lines.application_id = event.application_id
6042: AND lines.entity_code = event.entity_code

Line 6069: ra_customer_trx_lines_all ratrxlines

6065: FROM
6066: zx_transaction_lines_gt Lines,
6067: --zx_trx_headers_gt Headers,
6068: zx_evnt_cls_mappings event,
6069: ra_customer_trx_lines_all ratrxlines
6070: WHERE
6071: lines.application_id = 222
6072: AND lines.application_id = event.application_id
6073: AND lines.entity_code = event.entity_code