APPS.AR_INVOICE_UTILS dependencies on SO_SALES_CREDIT_TYPES

Line 7254: SO_SALES_CREDIT_TYPES CR

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

Line 7279: SO_SALES_CREDIT_TYPES CR,

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

Line 7370: FROM SO_SALES_CREDIT_TYPES CR

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
7371: WHERE CR.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID);
7372:
7373: l_message_name := gl_public_sector.get_message_name (
7374: p_message_name => 'AR_INAPI_INVLD_SCR_TYPE_NAME',

Line 7393: FROM SO_SALES_CREDIT_TYPES CR

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
7394: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME);
7395:
7396: -- update the sales credit type id
7397: UPDATE ar_trx_salescredits_gt SC

Line 7400: FROM SO_SALES_CREDIT_TYPES CR

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)
7402: WHERE SALES_CREDIT_TYPE_ID IS NULL;
7403:
7404: l_message_name := gl_public_sector.get_message_name (

Line 7608: SO_SALES_CREDIT_TYPES SCT

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
7612: (NVL(SC.revenue_percent_split, 0) -

Line 7629: SO_SALES_CREDIT_TYPES CR

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
7633: HAVING

Line 7656: so_sales_credit_types t

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

Line 7699: so_sales_credit_types type

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