APPS.AR_INVOICE_UTILS dependencies on SO_SALES_CREDIT_TYPES

Line 7593: SO_SALES_CREDIT_TYPES CR

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
7597: HAVING SUM(revenue_percent_split) <> 100;

Line 7618: SO_SALES_CREDIT_TYPES CR,

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
7622: and L.trx_LINE_ID = SC.trx_LINE_ID

Line 7709: FROM SO_SALES_CREDIT_TYPES CR

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
7710: WHERE CR.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID);
7711:
7712: l_message_name := gl_public_sector.get_message_name (
7713: p_message_name => 'AR_INAPI_INVLD_SCR_TYPE_NAME',

Line 7732: FROM SO_SALES_CREDIT_TYPES CR

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
7733: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME);
7734:
7735: -- update the sales credit type id
7736: UPDATE ar_trx_salescredits_gt SC

Line 7739: FROM SO_SALES_CREDIT_TYPES CR

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)
7741: WHERE SALES_CREDIT_TYPE_ID IS NULL;
7742:
7743: l_message_name := gl_public_sector.get_message_name (

Line 7758: so_sales_credit_types CR --Bug8202014

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
7762: AND cr.quota_flag = 'Y'; --Bug8202014

Line 8048: SO_SALES_CREDIT_TYPES SCT

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
8052: OR

Line 8070: SO_SALES_CREDIT_TYPES CR

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
8074: sc.trx_header_id, sc.trx_LINE_ID

Line 8098: so_sales_credit_types t

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'
8102: GROUP BY S.trx_header_id, S.trx_line_id

Line 8141: so_sales_credit_types type

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
8145: AND type.quota_flag = 'Y' );