APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_SUMMARIES

Line 3168: FROM oe_credit_summaries exs

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

Line 3195: FROM oe_credit_summaries exs

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

Line 3213: FROM oe_credit_summaries exs

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

Line 3236: FROM oe_credit_summaries

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

Line 3243: FROM oe_credit_summaries oes

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

Line 5889: FROM oe_credit_summaries

5885:
5886: -- External exposure cursor
5887: CURSOR cust_external_exposure_csr (p_curr_code IN VARCHAR2 default NULL) IS
5888: SELECT SUM(balance)
5889: FROM oe_credit_summaries
5890: WHERE balance_type = 18
5891: AND cust_account_id = p_customer_id
5892: AND NVL(org_id,-99) = G_ORG_ID
5893: AND currency_code = p_curr_code;

Line 5898: FROM oe_credit_summaries

5894:
5895: CURSOR cust_external_csr_global
5896: (p_curr_code IN VARCHAR2 default NULL) IS
5897: SELECT SUM(balance)
5898: FROM oe_credit_summaries
5899: WHERE balance_type = 18
5900: AND cust_account_id = p_customer_id
5901: AND currency_code = p_curr_code;
5902:

Line 6943: FROM oe_credit_summaries

6939:
6940: -- site external exposure cursor
6941: CURSOR site_external_exposure_csr (p_curr_code IN VARCHAR2 default NULL) IS
6942: SELECT SUM(balance)
6943: FROM oe_credit_summaries
6944: WHERE balance_type = 18
6945: AND site_use_id = p_site_use_id
6946: AND currency_code = p_curr_code;
6947: