eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INVOICE_UTILS dependencies on AR_TRX_SALESCREDITS_GT

Line 7592: FROM ar_trx_SALESCREDITS_gt SC,

7588: pct_precision NUMBER := 4;
7589: CURSOR cRounding IS
7590: SELECT trx_line_id, (100 - SUM(revenue_percent_split)) rounding_error,
7591: MAX(SC.trx_SALESCREDIT_ID) max_trx_salescredit_id
7592: FROM ar_trx_SALESCREDITS_gt SC,
7593: SO_SALES_CREDIT_TYPES CR
7594: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
7595: AND CR.QUOTA_FLAG = 'Y'
7596: GROUP BY trx_LINE_ID

Line 7617: ar_trx_SALESCREDITS_gt SC,

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'
7621: AND L.CURRENCY_CODE = C.CURRENCY_CODE

Line 7653: FROM ar_trx_salescredits_gt SC

7649: trx_LINE_ID,
7650: trx_SALESCREDIT_ID,
7651: arp_standard.fnd_message(l_message_name),
7652: sc.salesrep_id
7653: FROM ar_trx_salescredits_gt SC
7654: WHERE salesrep_id IS NOT NULL
7655: AND NOT EXISTS
7656: (SELECT 'X'
7657: FROM RA_SALESREPS REP

Line 7676: FROM ar_trx_salescredits_gt SC

7672: trx_LINE_ID,
7673: trx_salescredit_id,
7674: arp_standard.fnd_message(l_message_name),
7675: sc.salesrep_num
7676: FROM ar_trx_salescredits_gt SC
7677: WHERE sc.salesrep_num IS NOT NULL
7678: AND NOT EXISTS
7679: (SELECT 'X'
7680: FROM RA_SALESREPS REP

Line 7683: UPDATE ar_trx_salescredits_gt SC

7679: (SELECT 'X'
7680: FROM RA_SALESREPS REP
7681: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7682:
7683: UPDATE ar_trx_salescredits_gt SC
7684: SET SALESREP_ID = (SELECT SALESREP_ID
7685: FROM RA_SALESREPS REP
7686: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7687: WHERE salesrep_id IS NULL;

Line 7705: FROM ar_trx_salescredits_gt SC

7701: trx_LINE_ID,
7702: trx_SALESCREDIT_ID,
7703: arp_standard.fnd_message(l_message_name),
7704: sc.sales_credit_type_id
7705: FROM ar_trx_salescredits_gt SC
7706: WHERE sales_credit_type_id IS NOT NULL
7707: AND NOT EXISTS
7708: (SELECT 'X'
7709: FROM SO_SALES_CREDIT_TYPES CR

Line 7728: FROM ar_trx_salescredits_gt SC

7724: trx_line_id,
7725: trx_salescredit_id,
7726: arp_standard.fnd_message(l_message_name),
7727: sc.sales_credit_type_name
7728: FROM ar_trx_salescredits_gt SC
7729: WHERE sales_credit_type_name IS NOT NULL
7730: AND NOT EXISTS
7731: (SELECT 'X'
7732: FROM SO_SALES_CREDIT_TYPES CR

Line 7736: UPDATE ar_trx_salescredits_gt SC

7732: FROM SO_SALES_CREDIT_TYPES CR
7733: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME);
7734:
7735: -- update the sales credit type id
7736: UPDATE ar_trx_salescredits_gt SC
7737: SET SALES_CREDIT_TYPE_ID =
7738: (SELECT SALES_CREDIT_TYPE_ID
7739: FROM SO_SALES_CREDIT_TYPES CR
7740: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME)

Line 7757: FROM ar_trx_salescredits_gt SC,

7753: SELECT trx_header_id,
7754: trx_LINE_ID,
7755: trx_SALESCREDIT_ID,
7756: arp_standard.fnd_message(l_message_name)
7757: FROM ar_trx_salescredits_gt SC,
7758: so_sales_credit_types CR --Bug8202014
7759: WHERE sc.sales_credit_type_id = cr.sales_credit_type_id --Bug8202014
7760: AND revenue_amount_split IS NULL
7761: AND revenue_percent_split IS NULL

Line 7784: ar_trx_SALESCREDITS_gt S

7780: S.trx_SALESCREDIT_ID,
7781: arp_standard.fnd_message(l_message_name),
7782: L.LINE_TYPE
7783: FROM ar_trx_LINES_GT L,
7784: ar_trx_SALESCREDITS_gt S
7785: WHERE S.trx_LINE_ID = L.trx_LINE_ID
7786: AND L.LINE_TYPE <> 'LINE';
7787:
7788:

Line 7791: UPDATE ar_trx_SALESCREDITS_gt S1

7787:
7788:
7789:
7790: -- Depending on the amount passed update the percent split
7791: UPDATE ar_trx_SALESCREDITS_gt S1
7792: SET revenue_percent_split =
7793: (
7794: SELECT DECODE(DECODE(L.QUANTITY_invoiced * L.UNIT_SELLING_PRICE,
7795: NULL, L.extended_AMOUNT,

Line 7823: ar_trx_SALESCREDITS_gt S2

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
7827: AND S2.ROWID = S1.ROWID

Line 7834: UPDATE ar_trx_salescredits_gt SC

7830: AND S1.revenue_percent_split IS NULL;
7831:
7832:
7833: -- update amount split if percent has been passed
7834: UPDATE ar_trx_salescredits_gt SC
7835: SET revenue_amount_split =
7836: (SELECT DECODE(C.MINIMUM_ACCOUNTABLE_UNIT,
7837: NULL,
7838: ROUND(SC.revenue_percent_split *

Line 7886: UPDATE ar_trx_SALESCREDITS_gt S1

7882: Added the following 2 updated statements for this.
7883: *******************************************************************************/
7884:
7885: -- update non_revenue_percent_split if non_revenue_amount_split has been passed
7886: UPDATE ar_trx_SALESCREDITS_gt S1
7887: SET non_revenue_percent_split =
7888: (
7889: SELECT DECODE(DECODE(L.QUANTITY_invoiced * L.UNIT_SELLING_PRICE,
7890: NULL, L.extended_AMOUNT,

Line 7918: ar_trx_SALESCREDITS_gt S2

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
7922: AND S2.ROWID = S1.ROWID

Line 7929: UPDATE ar_trx_salescredits_gt SC

7925: AND S1.non_revenue_percent_split IS NULL;
7926:
7927:
7928: -- update non_revenue_amount_split if non_revenue_percent_split has been passed
7929: UPDATE ar_trx_salescredits_gt SC
7930: SET non_revenue_amount_split =
7931: (SELECT DECODE(C.MINIMUM_ACCOUNTABLE_UNIT,
7932: NULL,
7933: ROUND(SC.non_revenue_percent_split *

Line 7980: UPDATE ar_trx_SALESCREDITS_gt

7976:
7977: -- fix rounding error if any in percent
7978: FOR cRoundingRec IN cRounding
7979: LOOP
7980: UPDATE ar_trx_SALESCREDITS_gt
7981: SET revenue_percent_split = revenue_percent_split + cRoundingRec.rounding_error
7982: WHERE trx_SALESCREDIT_ID = cRoundingRec.max_trx_salescredit_id;
7983: END LOOP;
7984:

Line 7988: UPDATE ar_trx_SALESCREDITS_gt

7984:
7985: -- fix rounding error in amount if any
7986: For cRoundingAmtRec IN cRoundingAmt
7987: LOOP
7988: UPDATE ar_trx_SALESCREDITS_gt
7989: SET revenue_amount_split = revenue_amount_split +
7990: (cRoundingAmtRec.line_amount -
7991: cRoundingAmtRec.sales_credit_amount)
7992: WHERE trx_SALESCREDIT_ID = cRoundingAmtRec.max_trx_salescredit_id;

Line 8009: FROM ar_trx_salescredits_gt S,

8005: S.trx_LINE_ID,
8006: S.trx_SALESCREDIT_ID,
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

Line 8047: FROM ar_trx_salescredits_gt SC,

8043: SC.trx_LINE_ID,
8044: SC.trx_SALESCREDIT_ID,
8045: arp_standard.fnd_message(l_message_name),
8046: SC.revenue_percent_split
8047: FROM ar_trx_salescredits_gt SC,
8048: SO_SALES_CREDIT_TYPES SCT
8049: WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
8050: AND SCT.QUOTA_FLAG = 'Y' --Bug8202014
8051: AND ( SC.revenue_percent_split IS NULL

Line 8069: ar_trx_salescredits_gt SC,

8065: SELECT SC.trx_header_id,
8066: SC.trx_LINE_ID,
8067: arp_standard.fnd_message(l_message_name)
8068: FROM
8069: ar_trx_salescredits_gt SC,
8070: SO_SALES_CREDIT_TYPES CR
8071: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
8072: AND cr.quota_flag = 'Y' --Bug8202014
8073: GROUP BY

Line 8097: FROM ar_trx_salescredits_gt s,

8093: SELECT s.trx_header_id,
8094: s.trx_line_id,
8095: arp_standard.fnd_message(l_message_name),
8096: SUM(S.revenue_amount_split)
8097: FROM ar_trx_salescredits_gt s,
8098: so_sales_credit_types t
8099: WHERE s.sales_credit_type_id = t.sales_credit_type_id
8100: AND s.revenue_amount_split IS NOT NULL
8101: AND t.quota_flag = 'Y'

Line 8140: FROM ar_trx_salescredits_gt scgt,

8136: FROM ar_trx_lines_gt lgt
8137: WHERE lgt.line_type = 'LINE'
8138: AND NOT EXISTS
8139: (SELECT 'X'
8140: FROM ar_trx_salescredits_gt scgt,
8141: so_sales_credit_types type
8142: WHERE scgt.trx_header_id = lgt.trx_header_id
8143: AND scgt.trx_line_id = lgt.trx_line_id
8144: AND scgt.sales_credit_type_id = type.sales_credit_type_id