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.OE_CREDIT_CHECK_UTIL dependencies on HZ_CREDIT_USAGE_RULE_SETS_B

Line 899: , hz_credit_usage_rule_sets_B curs

895: , curs.credit_usage_rule_set_id credit_usage_rule_set_id
896: FROM hz_customer_profiles cp
897: , hz_cust_profile_amts cpa
898: , hz_credit_usages cu
899: , hz_credit_usage_rule_sets_B curs
900: WHERE cp.cust_account_id = p_entity_id
901: AND cp.site_use_id IS NULL
902: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
903: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 917: , hz_credit_usage_rule_sets_B curs

913: , curs.credit_usage_rule_set_id credit_usage_rule_set_id
914: FROM hz_credit_profiles cp
915: , hz_credit_profile_amts cpa
916: , hz_credit_usages cu
917: , hz_credit_usage_rule_sets_B curs
918: WHERE cp.organization_id = p_entity_id
919: AND cp.credit_profile_id = cpa.credit_profile_id
920: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
921: AND cu.credit_usage_rule_set_id = curs.credit_usage_rule_set_id

Line 1048: HZ_CREDIT_USAGE_RULE_SETS_B

1044: NVL(global_exposure_flag,'N')
1045: INTO
1046: l_global_exposure_flag
1047: FROM
1048: HZ_CREDIT_USAGE_RULE_SETS_B
1049: WHERE
1050: credit_usage_rule_set_id = p_credit_usage_rule_set_id ;
1051:
1052: EXCEPTION

Line 1506: , hz_credit_usage_rule_sets_B curs

1502: FROM hz_customer_profiles cp
1503: , hz_cust_profile_amts cpa
1504: , hz_credit_usages cu
1505: , hz_credit_usage_rules cur
1506: , hz_credit_usage_rule_sets_B curs
1507: WHERE cp.cust_account_id = p_entity_id
1508: AND cp.site_use_id IS NULL
1509: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1510: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 1539: , hz_credit_usage_rule_sets_B curs

1535: FROM hz_customer_profiles cp
1536: , hz_cust_profile_amts cpa
1537: , hz_credit_usages cu
1538: , hz_credit_usage_rules cur
1539: , hz_credit_usage_rule_sets_B curs
1540: WHERE cp.cust_account_id = p_entity_id
1541: AND cp.site_use_id IS NULL
1542: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1543: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 1953: , hz_credit_usage_rule_sets_B curs

1949: FROM hz_credit_profiles cp
1950: , hz_credit_profile_amts cpa
1951: , hz_credit_usages cu
1952: , hz_credit_usage_rules cur
1953: , hz_credit_usage_rule_sets_B curs
1954: WHERE cp.organization_id = G_ORG_ID
1955: AND cp.credit_profile_id = cpa.credit_profile_id
1956: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
1957: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 1990: , hz_credit_usage_rule_sets_B curs

1986: FROM hz_credit_profiles cp
1987: , hz_credit_profile_amts cpa
1988: , hz_credit_usages cu
1989: , hz_credit_usage_rules cur
1990: , hz_credit_usage_rule_sets_B curs
1991: WHERE cp.organization_id = G_ORG_ID
1992: AND cp.credit_profile_id = cpa.credit_profile_id
1993: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
1994: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id