[Home] [Help]
1547: FROM ar_trx_header_gt gt
1548: WHERE gt.trx_currency IS NOT NULL
1549: AND NOT EXISTS (
1550: SELECT 'X'
1551: FROM fnd_currencies c
1552: WHERE c.currency_code = gt.trx_currency
1553: AND gt.trx_date BETWEEN NVL(c.start_date_active, gt.trx_date)
1554: AND NVL(c.end_date_active, gt.trx_date) );
1555:
7080: p_trx_system_parameters_rec AR_INVOICE_DEFAULT_PVT.trx_system_parameters_rec_type,
7081: x_errmsg OUT NOCOPY VARCHAR2,
7082: x_return_status OUT NOCOPY VARCHAR2 ) IS
7083:
7084: l_precision fnd_currencies.precision%type;
7085: l_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
7086: -- bug 6429861
7087: l_per number := 1;
7088: l_amt number := 1;
7081: x_errmsg OUT NOCOPY VARCHAR2,
7082: x_return_status OUT NOCOPY VARCHAR2 ) IS
7083:
7084: l_precision fnd_currencies.precision%type;
7085: l_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
7086: -- bug 6429861
7087: l_per number := 1;
7088: l_amt number := 1;
7089:
7195: ROUND(((D.PERCENT * L.extended_AMOUNT) / 100) /
7196: C.MINIMUM_ACCOUNTABLE_UNIT) *
7197: C.MINIMUM_ACCOUNTABLE_UNIT
7198: )
7199: FROM FND_CURRENCIES C,
7200: ar_trx_LINES_GT L
7201: WHERE L.CURRENCY_CODE = C.CURRENCY_CODE
7202: AND L.trx_LINE_ID = D.trx_LINE_ID
7203: )
7229: (
7230: SELECT DECODE(L.extended_AMOUNT,
7231: 0, 0, /* set percent =0 if line amt = 0 */
7232: ROUND(100 * (D.AMOUNT / L.extended_AMOUNT), 4))
7233: FROM FND_CURRENCIES C,
7234: ar_trx_LINES_GT L
7235: WHERE L.CURRENCY_CODE = C.CURRENCY_CODE
7236: AND L.trx_LINE_ID = D.trx_LINE_ID
7237: )
7265: ROUND(((D.PERCENT * L.extended_AMOUNT * nvl(h.exchange_rate,1)) / 100) /
7266: C.MINIMUM_ACCOUNTABLE_UNIT) *
7267: C.MINIMUM_ACCOUNTABLE_UNIT
7268: )
7269: FROM FND_CURRENCIES C,
7270: ar_trx_LINES_GT L,
7271: ar_trx_header_gt h
7272: WHERE C.CURRENCY_CODE = p_trx_system_parameters_rec.base_currency_code
7273: AND L.trx_LINE_ID = D.trx_LINE_ID
7521: NULL))
7522: FROM ar_trx_DIST_gt D,
7523: ar_trx_header_gt h
7524: --RA_CUST_TRX_TYPES TYPE,
7525: FND_CURRENCIES C,
7526: GL_SETS_OF_BOOKS G,
7527: --RA_CUSTOMER_TRX PREV_TRX,
7528: ar_trx_LINES_GT L_PARENT,
7529: ar_trx_LINES_GT L
7612: )
7613: ) line_amount,
7614: MAX(SC.trx_SALESCREDIT_ID) max_trx_salescredit_id,
7615: SUM(revenue_amount_split) sales_credit_amount
7616: FROM FND_CURRENCIES C,
7617: ar_trx_SALESCREDITS_gt SC,
7618: SO_SALES_CREDIT_TYPES CR,
7619: ar_trx_LINES_GT L
7620: WHERE L.LINE_TYPE = 'LINE'
7818: )
7819: ),
7820: pct_precision))
7821: FROM ar_trx_LINES_GT L,
7822: FND_CURRENCIES C,
7823: ar_trx_SALESCREDITS_gt S2
7824: WHERE L.trx_LINE_ID = S2.trx_LINE_ID
7825: AND L.LINE_TYPE = 'LINE'
7826: AND L.CURRENCY_CODE = C.CURRENCY_CODE
7868: C.MINIMUM_ACCOUNTABLE_UNIT)
7869: * C.MINIMUM_ACCOUNTABLE_UNIT
7870: )
7871: FROM ar_trx_LINES_GT L,
7872: FND_CURRENCIES C
7873: WHERE L.trx_LINE_ID = SC.trx_LINE_ID
7874: AND L.CURRENCY_CODE = C.CURRENCY_CODE)
7875: WHERE SC.revenue_percent_split IS NOT NULL
7876: AND SC.revenue_amount_split IS NULL;
7913: )
7914: ),
7915: pct_precision))
7916: FROM ar_trx_LINES_GT L,
7917: FND_CURRENCIES C,
7918: ar_trx_SALESCREDITS_gt S2
7919: WHERE L.trx_LINE_ID = S2.trx_LINE_ID
7920: AND L.LINE_TYPE = 'LINE'
7921: AND L.CURRENCY_CODE = C.CURRENCY_CODE
7963: C.MINIMUM_ACCOUNTABLE_UNIT)
7964: * C.MINIMUM_ACCOUNTABLE_UNIT
7965: )
7966: FROM ar_trx_LINES_GT L,
7967: FND_CURRENCIES C
7968: WHERE L.trx_LINE_ID = SC.trx_LINE_ID
7969: AND L.CURRENCY_CODE = C.CURRENCY_CODE)
7970: WHERE SC.non_revenue_percent_split IS NOT NULL
7971: AND SC.non_revenue_amount_split IS NULL;
8007: arp_standard.fnd_message('AR_INAPI_INVALID_PRECISION'),
8008: S.revenue_amount_split
8009: FROM ar_trx_salescredits_gt S,
8010: ar_trx_LINES_GT L,
8011: FND_CURRENCIES C
8012: WHERE S.trx_LINE_ID = L.trx_LINE_ID
8013: AND L.CURRENCY_CODE = C.CURRENCY_CODE
8014: AND s.revenue_amount_split IS NOT NULL
8015: GROUP BY S.trx_header_id, S.trx_LINE_ID,
8109: ROUND(l.quantity_invoiced * l.unit_selling_price
8110: / c.minimum_accountable_unit) *
8111: c.minimum_accountable_unit))
8112: FROM ar_trx_lines_gt l,
8113: fnd_currencies c
8114: WHERE l.trx_line_id = s.trx_line_id
8115: AND l.line_type = 'LINE'
8116: AND l.currency_code = c.currency_code);
8117: