[Home] [Help]
1506: FROM ar_trx_header_gt gt
1507: WHERE gt.trx_currency IS NOT NULL
1508: AND NOT EXISTS (
1509: SELECT 'X'
1510: FROM fnd_currencies c
1511: WHERE c.currency_code = gt.trx_currency
1512: AND gt.trx_date BETWEEN NVL(c.start_date_active, gt.trx_date)
1513: AND NVL(c.end_date_active, gt.trx_date) );
1514:
6756: p_trx_system_parameters_rec AR_INVOICE_DEFAULT_PVT.trx_system_parameters_rec_type,
6757: x_errmsg OUT NOCOPY VARCHAR2,
6758: x_return_status OUT NOCOPY VARCHAR2 ) IS
6759:
6760: l_precision fnd_currencies.precision%type;
6761: l_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
6762:
6763: BEGIN
6764: IF pg_debug = 'Y'
6757: x_errmsg OUT NOCOPY VARCHAR2,
6758: x_return_status OUT NOCOPY VARCHAR2 ) IS
6759:
6760: l_precision fnd_currencies.precision%type;
6761: l_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
6762:
6763: BEGIN
6764: IF pg_debug = 'Y'
6765: THEN
6867: ROUND(((D.PERCENT * L.extended_AMOUNT) / 100) /
6868: C.MINIMUM_ACCOUNTABLE_UNIT) *
6869: C.MINIMUM_ACCOUNTABLE_UNIT
6870: )
6871: FROM FND_CURRENCIES C,
6872: ar_trx_LINES_GT L
6873: WHERE L.CURRENCY_CODE = C.CURRENCY_CODE
6874: AND L.trx_LINE_ID = D.trx_LINE_ID
6875: )
6898: (
6899: SELECT DECODE(L.extended_AMOUNT,
6900: 0, 0, /* set percent =0 if line amt = 0 */
6901: ROUND(100 * (D.AMOUNT / L.extended_AMOUNT), 4))
6902: FROM FND_CURRENCIES C,
6903: ar_trx_LINES_GT L
6904: WHERE L.CURRENCY_CODE = C.CURRENCY_CODE
6905: AND L.trx_LINE_ID = D.trx_LINE_ID
6906: )
6930: ROUND(((D.PERCENT * L.extended_AMOUNT * nvl(h.exchange_rate,1)) / 100) /
6931: C.MINIMUM_ACCOUNTABLE_UNIT) *
6932: C.MINIMUM_ACCOUNTABLE_UNIT
6933: )
6934: FROM FND_CURRENCIES C,
6935: ar_trx_LINES_GT L,
6936: ar_trx_header_gt h
6937: WHERE C.CURRENCY_CODE = p_trx_system_parameters_rec.base_currency_code
6938: AND L.trx_LINE_ID = D.trx_LINE_ID
7182: NULL))
7183: FROM ar_trx_DIST_gt D,
7184: ar_trx_header_gt h
7185: --RA_CUST_TRX_TYPES TYPE,
7186: FND_CURRENCIES C,
7187: GL_SETS_OF_BOOKS G,
7188: --RA_CUSTOMER_TRX PREV_TRX,
7189: ar_trx_LINES_GT L_PARENT,
7190: ar_trx_LINES_GT L
7273: )
7274: ) line_amount,
7275: MAX(SC.trx_SALESCREDIT_ID) max_trx_salescredit_id,
7276: SUM(revenue_amount_split) sales_credit_amount
7277: FROM FND_CURRENCIES C,
7278: ar_trx_SALESCREDITS_gt SC,
7279: SO_SALES_CREDIT_TYPES CR,
7280: ar_trx_LINES_GT L
7281: WHERE L.LINE_TYPE = 'LINE'
7476: )
7477: ),
7478: pct_precision))
7479: FROM ar_trx_LINES_GT L,
7480: FND_CURRENCIES C,
7481: ar_trx_SALESCREDITS_gt S2
7482: WHERE L.trx_LINE_ID = S2.trx_LINE_ID
7483: AND L.LINE_TYPE = 'LINE'
7484: AND L.CURRENCY_CODE = C.CURRENCY_CODE
7526: C.MINIMUM_ACCOUNTABLE_UNIT)
7527: * C.MINIMUM_ACCOUNTABLE_UNIT
7528: )
7529: FROM ar_trx_LINES_GT L,
7530: FND_CURRENCIES C
7531: WHERE L.trx_LINE_ID = SC.trx_LINE_ID
7532: AND L.CURRENCY_CODE = C.CURRENCY_CODE)
7533: WHERE SC.revenue_percent_split IS NOT NULL
7534: AND SC.revenue_amount_split IS NULL;
7567: arp_standard.fnd_message('AR_INAPI_INVALID_PRECISION'),
7568: S.revenue_amount_split
7569: FROM ar_trx_salescredits_gt S,
7570: ar_trx_LINES_GT L,
7571: FND_CURRENCIES C
7572: WHERE S.trx_LINE_ID = L.trx_LINE_ID
7573: AND L.CURRENCY_CODE = C.CURRENCY_CODE
7574: AND s.revenue_amount_split IS NOT NULL
7575: GROUP BY S.trx_header_id, S.trx_LINE_ID,
7667: ROUND(l.quantity_invoiced * l.unit_selling_price
7668: / c.minimum_accountable_unit) *
7669: c.minimum_accountable_unit))
7670: FROM ar_trx_lines_gt l,
7671: fnd_currencies c
7672: WHERE l.trx_line_id = s.trx_line_id
7673: AND l.line_type = 'LINE'
7674: AND l.currency_code = c.currency_code);
7675: