[Home] [Help]
1644:
1645: SELECT nvl(c.code_combination_id,-1)
1646: INTO p_ccid_rev
1647: FROM
1648: ra_customer_trx t,
1649: ra_customer_trx_lines l,
1650: mtl_item_categories i,
1651: so_agreements a,
1652: ra_account_combinations c
1645: SELECT nvl(c.code_combination_id,-1)
1646: INTO p_ccid_rev
1647: FROM
1648: ra_customer_trx t,
1649: ra_customer_trx_lines l,
1650: mtl_item_categories i,
1651: so_agreements a,
1652: ra_account_combinations c
1653: WHERE t.customer_trx_id = l.customer_trx_id
2383: IF( p_account_class in ( TAX, FREIGHT ) ) THEN
2384:
2385: /* 4558268 - Removed tax tables */
2386: l_tax_table := CRLF ||
2387: 'ra_customer_trx_lines ctl_line,';
2388:
2389: END IF;
2390:
2391: IF( p_account_class = REC ) THEN
2535: IF p_request_id > 0
2536: THEN
2537:
2538: /* 5169215 - a cartesian join between ra_interface_lines and
2539: ra_customer_trx was resulting in incorrect GL_DATE on
2540: REC distributions. This relates to bug 4483951, but the fix
2541: for that does not entirely resolve the problem */
2542: l_interface_table_pred := CRLF ||
2543: 'AND ril.rowid = (SELECT /*+ no_unnest */ min(ril2.rowid)
2640: /* 7039838 - changed hints for FT tuning */
2641: IF p_request_id IS NOT NULL
2642: THEN
2643: l_select_stmt :=
2644: 'SELECT /*+ index(ct,RA_CUSTOMER_TRX_N15) index(ctl,RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ' || CRLF;
2645: ELSE
2646: l_select_stmt := 'SELECT' || CRLF;
2647: END IF;
2648:
2679: 'fnd_currencies fc_foreign,'
2680: || l_gl_dist_table
2681: || CRLF ||
2682: 'ra_cust_trx_line_gl_dist rgd,
2683: ra_customer_trx_lines ctl,
2684: ra_customer_trx ct
2685: WHERE ct.customer_trx_id = ctl.customer_trx_id(+)
2686: AND ct.invoice_currency_code = fc_foreign.currency_code'
2687: || l_cm_module_pred
2680: || l_gl_dist_table
2681: || CRLF ||
2682: 'ra_cust_trx_line_gl_dist rgd,
2683: ra_customer_trx_lines ctl,
2684: ra_customer_trx ct
2685: WHERE ct.customer_trx_id = ctl.customer_trx_id(+)
2686: AND ct.invoice_currency_code = fc_foreign.currency_code'
2687: || l_cm_module_pred
2688: || l_prevent_dup_rec_pred
4818: l_ctlid_pred := CRLF ||
4819: 'AND customer_trx_line_id in
4820: (
4821: SELECT customer_trx_line_id
4822: FROM ra_customer_trx_lines ctl
4823: WHERE (ctl.customer_trx_line_id = '
4824: || to_char( p_customer_trx_line_id ) || CRLF ||
4825: ' or ctl.link_to_cust_trx_line_id = '
4826: || to_char( p_customer_trx_line_id ) || ')' || CRLF ||
4862: || CRLF ||
4863: 'AND account_set_flag = (SELECT decode(ct.invoicing_rule_id,
4864: NULL, ''N'',
4865: ''Y'')
4866: FROM ra_customer_trx ct
4867: WHERE ct.customer_trx_id = gd.customer_trx_id)';
4868:
4869:
4870: debug( l_delete_stmt, MSG_LEVEL_DEBUG );
6490: l_no_rows_unbill BOOLEAN := FALSE;
6491: l_no_rows_unearn BOOLEAN := FALSE;
6492: l_no_rows_suspense BOOLEAN := FALSE;
6493: l_no_rows_charges BOOLEAN := FALSE;
6494: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
6495: l_create_clearing_flag ra_batch_sources.create_clearing_flag%type;
6496: l_line_type ra_customer_trx_lines.line_type%type;
6497: BEGIN
6498:
6492: l_no_rows_suspense BOOLEAN := FALSE;
6493: l_no_rows_charges BOOLEAN := FALSE;
6494: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
6495: l_create_clearing_flag ra_batch_sources.create_clearing_flag%type;
6496: l_line_type ra_customer_trx_lines.line_type%type;
6497: BEGIN
6498:
6499: debug( ' Processing ALL mode...', MSG_LEVEL_DEBUG );
6500:
6503: SELECT invoicing_rule_id,
6504: create_clearing_flag
6505: INTO l_invoicing_rule_id,
6506: l_create_clearing_flag
6507: FROM ra_customer_trx t,
6508: ra_batch_sources b
6509: WHERE customer_trx_id = p_customer_trx_id
6510: AND t.batch_source_id = b.batch_source_id;
6511: END IF;
6513: IF ( p_customer_trx_line_id IS NOT NULL )
6514: THEN
6515: SELECT line_type
6516: INTO l_line_type
6517: FROM ra_customer_trx_lines
6518: WHERE customer_trx_line_id = p_customer_trx_line_id;
6519: END IF;
6520:
6521: BEGIN
6991: --
6992: IF ( p_customer_trx_id IS NOT NULL) THEN
6993: SELECT t.bill_to_site_use_id
6994: INTO l_bill_to_site_use_id
6995: FROM ra_customer_trx t
6996: WHERE t.customer_trx_id = p_customer_trx_id;
6997: END IF;
6998:
6999: --