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 7253: FROM ar_trx_SALESCREDITS_gt SC,

7249: pct_precision NUMBER := 4;
7250: CURSOR cRounding IS
7251: SELECT trx_line_id, (100 - SUM(revenue_percent_split)) rounding_error,
7252: MAX(SC.trx_SALESCREDIT_ID) max_trx_salescredit_id
7253: FROM ar_trx_SALESCREDITS_gt SC,
7254: SO_SALES_CREDIT_TYPES CR
7255: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
7256: AND CR.QUOTA_FLAG = 'Y'
7257: GROUP BY trx_LINE_ID

Line 7278: ar_trx_SALESCREDITS_gt SC,

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

Line 7314: FROM ar_trx_salescredits_gt SC

7310: trx_LINE_ID,
7311: trx_SALESCREDIT_ID,
7312: arp_standard.fnd_message(l_message_name),
7313: sc.salesrep_id
7314: FROM ar_trx_salescredits_gt SC
7315: WHERE salesrep_id IS NOT NULL
7316: AND NOT EXISTS
7317: (SELECT 'X'
7318: FROM RA_SALESREPS REP

Line 7337: FROM ar_trx_salescredits_gt SC

7333: trx_LINE_ID,
7334: trx_salescredit_id,
7335: arp_standard.fnd_message(l_message_name),
7336: sc.salesrep_num
7337: FROM ar_trx_salescredits_gt SC
7338: WHERE sc.salesrep_num IS NOT NULL
7339: AND NOT EXISTS
7340: (SELECT 'X'
7341: FROM RA_SALESREPS REP

Line 7344: UPDATE ar_trx_salescredits_gt SC

7340: (SELECT 'X'
7341: FROM RA_SALESREPS REP
7342: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7343:
7344: UPDATE ar_trx_salescredits_gt SC
7345: SET SALESREP_ID = (SELECT SALESREP_ID
7346: FROM RA_SALESREPS REP
7347: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7348: WHERE salesrep_id IS NULL;

Line 7366: FROM ar_trx_salescredits_gt SC

7362: trx_LINE_ID,
7363: trx_SALESCREDIT_ID,
7364: arp_standard.fnd_message(l_message_name),
7365: sc.sales_credit_type_id
7366: FROM ar_trx_salescredits_gt SC
7367: WHERE sales_credit_type_id IS NOT NULL
7368: AND NOT EXISTS
7369: (SELECT 'X'
7370: FROM SO_SALES_CREDIT_TYPES CR

Line 7389: FROM ar_trx_salescredits_gt SC

7385: trx_line_id,
7386: trx_salescredit_id,
7387: arp_standard.fnd_message(l_message_name),
7388: sc.sales_credit_type_name
7389: FROM ar_trx_salescredits_gt SC
7390: WHERE sales_credit_type_name IS NOT NULL
7391: AND NOT EXISTS
7392: (SELECT 'X'
7393: FROM SO_SALES_CREDIT_TYPES CR

Line 7397: UPDATE ar_trx_salescredits_gt SC

7393: FROM SO_SALES_CREDIT_TYPES CR
7394: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME);
7395:
7396: -- update the sales credit type id
7397: UPDATE ar_trx_salescredits_gt SC
7398: SET SALES_CREDIT_TYPE_ID =
7399: (SELECT SALES_CREDIT_TYPE_ID
7400: FROM SO_SALES_CREDIT_TYPES CR
7401: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME)

Line 7418: FROM ar_trx_salescredits_gt SC

7414: SELECT trx_header_id,
7415: trx_LINE_ID,
7416: trx_SALESCREDIT_ID,
7417: arp_standard.fnd_message(l_message_name)
7418: FROM ar_trx_salescredits_gt SC
7419: WHERE revenue_amount_split IS NULL
7420: AND revenue_percent_split IS NULL;
7421:
7422:

Line 7442: ar_trx_SALESCREDITS_gt S

7438: S.trx_SALESCREDIT_ID,
7439: arp_standard.fnd_message(l_message_name),
7440: L.LINE_TYPE
7441: FROM ar_trx_LINES_GT L,
7442: ar_trx_SALESCREDITS_gt S
7443: WHERE S.trx_LINE_ID = L.trx_LINE_ID
7444: AND L.LINE_TYPE <> 'LINE';
7445:
7446:

Line 7449: UPDATE ar_trx_SALESCREDITS_gt S1

7445:
7446:
7447:
7448: -- Depending on the amount passed update the percent split
7449: UPDATE ar_trx_SALESCREDITS_gt S1
7450: SET revenue_percent_split =
7451: (
7452: SELECT DECODE(DECODE(L.QUANTITY_invoiced * L.UNIT_SELLING_PRICE,
7453: NULL, L.extended_AMOUNT,

Line 7481: ar_trx_SALESCREDITS_gt S2

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

Line 7492: UPDATE ar_trx_salescredits_gt SC

7488: AND S1.revenue_percent_split IS NULL;
7489:
7490:
7491: -- update amount split if percent has been passed
7492: UPDATE ar_trx_salescredits_gt SC
7493: SET revenue_amount_split =
7494: (SELECT DECODE(C.MINIMUM_ACCOUNTABLE_UNIT,
7495: NULL,
7496: ROUND(SC.revenue_percent_split *

Line 7540: UPDATE ar_trx_SALESCREDITS_gt

7536:
7537: -- fix rounding error if any in percent
7538: FOR cRoundingRec IN cRounding
7539: LOOP
7540: UPDATE ar_trx_SALESCREDITS_gt
7541: SET revenue_percent_split = revenue_percent_split + cRoundingRec.rounding_error
7542: WHERE trx_SALESCREDIT_ID = cRoundingRec.max_trx_salescredit_id;
7543: END LOOP;
7544:

Line 7548: UPDATE ar_trx_SALESCREDITS_gt

7544:
7545: -- fix rounding error in amount if any
7546: For cRoundingAmtRec IN cRoundingAmt
7547: LOOP
7548: UPDATE ar_trx_SALESCREDITS_gt
7549: SET revenue_amount_split = revenue_amount_split +
7550: (cRoundingAmtRec.line_amount -
7551: cRoundingAmtRec.sales_credit_amount)
7552: WHERE trx_SALESCREDIT_ID = cRoundingAmtRec.max_trx_salescredit_id;

Line 7569: FROM ar_trx_salescredits_gt S,

7565: S.trx_LINE_ID,
7566: S.trx_SALESCREDIT_ID,
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

Line 7607: FROM ar_trx_salescredits_gt SC,

7603: SC.trx_LINE_ID,
7604: SC.trx_SALESCREDIT_ID,
7605: arp_standard.fnd_message(l_message_name),
7606: SC.revenue_percent_split
7607: FROM ar_trx_salescredits_gt SC,
7608: SO_SALES_CREDIT_TYPES SCT
7609: WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
7610: AND ( SC.revenue_percent_split IS NULL
7611: OR

Line 7628: ar_trx_salescredits_gt SC,

7624: SELECT SC.trx_header_id,
7625: SC.trx_LINE_ID,
7626: arp_standard.fnd_message(l_message_name)
7627: FROM
7628: ar_trx_salescredits_gt SC,
7629: SO_SALES_CREDIT_TYPES CR
7630: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
7631: GROUP BY
7632: sc.trx_header_id, sc.trx_LINE_ID

Line 7655: FROM ar_trx_salescredits_gt s,

7651: SELECT s.trx_header_id,
7652: s.trx_line_id,
7653: arp_standard.fnd_message(l_message_name),
7654: SUM(S.revenue_amount_split)
7655: FROM ar_trx_salescredits_gt s,
7656: so_sales_credit_types t
7657: WHERE s.sales_credit_type_id = t.sales_credit_type_id
7658: AND s.revenue_amount_split IS NOT NULL
7659: AND t.quota_flag = 'Y'

Line 7698: FROM ar_trx_salescredits_gt scgt,

7694: FROM ar_trx_lines_gt lgt
7695: WHERE lgt.line_type = 'LINE'
7696: AND NOT EXISTS
7697: (SELECT 'X'
7698: FROM ar_trx_salescredits_gt scgt,
7699: so_sales_credit_types type
7700: WHERE scgt.trx_header_id = lgt.trx_header_id
7701: AND scgt.trx_line_id = lgt.trx_line_id
7702: AND scgt.sales_credit_type_id = type.sales_credit_type_id