APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_SUMMARIES

Line 3167: FROM oe_credit_summaries exs

3163: AND cas.cust_account_id = p_entity_id
3164: GROUP BY invoice_currency_code
3165: UNION
3166: SELECT exs.currency_code
3167: FROM oe_credit_summaries exs
3168: WHERE exs.balance_type = 18
3169: AND exs.cust_account_id = p_entity_id
3170: AND NVL(exs.org_id,-99) = G_ORG_ID; /* MOAC_SQL_CHANGE */
3171:

Line 3194: FROM oe_credit_summaries exs

3190: AND cas.cust_account_id = p_entity_id
3191: GROUP BY invoice_currency_code
3192: UNION
3193: SELECT exs.currency_code
3194: FROM oe_credit_summaries exs
3195: WHERE exs.balance_type = 18
3196: AND exs.cust_account_id = p_entity_id ;
3197:
3198:

Line 3212: FROM oe_credit_summaries exs

3208: WHERE pay.customer_site_use_id = p_entity_id
3209: GROUP BY invoice_currency_code
3210: UNION
3211: SELECT exs.currency_code
3212: FROM oe_credit_summaries exs
3213: WHERE balance_type = 18
3214: AND site_use_id = p_entity_id ;
3215:
3216:

Line 3235: FROM oe_credit_summaries

3231: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;
3232:
3233: CURSOR party_txn_cur IS
3234: SELECT distinct ( currency_code) user_code
3235: FROM oe_credit_summaries
3236: WHERE party_id = p_entity_id
3237: AND bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;
3238:
3239:

Line 3242: FROM oe_credit_summaries oes

3238:
3239:
3240: CURSOR party_h_txn_cur IS
3241: SELECT distinct ( oes.currency_code) user_code
3242: FROM oe_credit_summaries oes
3243: , hz_hierarchy_nodes hn
3244: WHERE hn.parent_id = p_entity_id
3245: AND hn.parent_object_type = 'ORGANIZATION'
3246: and hn.parent_table_name = 'HZ_PARTIES'

Line 5683: FROM oe_credit_summaries

5679:
5680: -- External exposure cursor
5681: CURSOR cust_external_exposure_csr (p_curr_code IN VARCHAR2 default NULL) IS
5682: SELECT SUM(balance)
5683: FROM oe_credit_summaries
5684: WHERE balance_type = 18
5685: AND cust_account_id = p_customer_id
5686: AND NVL(org_id,-99) = G_ORG_ID
5687: AND currency_code = p_curr_code;

Line 5692: FROM oe_credit_summaries

5688:
5689: CURSOR cust_external_csr_global
5690: (p_curr_code IN VARCHAR2 default NULL) IS
5691: SELECT SUM(balance)
5692: FROM oe_credit_summaries
5693: WHERE balance_type = 18
5694: AND cust_account_id = p_customer_id
5695: AND currency_code = p_curr_code;
5696:

Line 6687: FROM oe_credit_summaries

6683:
6684: -- site external exposure cursor
6685: CURSOR site_external_exposure_csr (p_curr_code IN VARCHAR2 default NULL) IS
6686: SELECT SUM(balance)
6687: FROM oe_credit_summaries
6688: WHERE balance_type = 18
6689: AND site_use_id = p_site_use_id
6690: AND currency_code = p_curr_code;
6691: