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_USAGES

Line 256: , hz_credit_usages cu

252: , cu.credit_usage_rule_set_id
253: , cp.party_id
254: FROM hz_customer_profiles cp
255: , hz_cust_profile_amts cpa
256: , hz_credit_usages cu
257: , hz_credit_usage_rules cur
258: , hz_hierarchy_nodes hn
259: WHERE cp.party_id = hn.parent_id
260: AND cp.cust_account_id = -1

Line 295: , hz_credit_usages cu

291: , cu.credit_usage_rule_set_id
292: , cp.party_id
293: FROM hz_customer_profiles cp
294: , hz_cust_profile_amts cpa
295: , hz_credit_usages cu
296: , hz_credit_usage_rules cur
297: , hz_hierarchy_nodes hn
298: WHERE cp.party_id = hn.parent_id
299: AND cp.cust_account_id = -1

Line 580: , hz_credit_usages cu

576: , cu.credit_usage_rule_set_id
577: , cp.party_id
578: FROM hz_customer_profiles cp
579: , hz_cust_profile_amts cpa
580: , hz_credit_usages cu
581: , hz_credit_usage_rules cur
582: WHERE cp.cust_account_id = -1
583: AND cp.site_use_id IS NULL
584: AND cp.party_id = p_party_id

Line 612: , hz_credit_usages cu

608: , cu.credit_usage_rule_set_id
609: , cp.party_id
610: FROM hz_customer_profiles cp
611: , hz_cust_profile_amts cpa
612: , hz_credit_usages cu
613: , hz_credit_usage_rules cur
614: WHERE cp.cust_account_id = -1
615: AND cp.site_use_id IS NULL
616: AND cp.party_id = p_party_id

Line 898: , hz_credit_usages cu

894: SELECT NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 916: , hz_credit_usages cu

912: SELECT NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 1504: , hz_credit_usages cu

1500: , cu.credit_usage_id
1501: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 1537: , hz_credit_usages cu

1533: , cu.credit_usage_rule_set_id
1534: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 1690: , hz_credit_usages cu

1686: , cp.credit_checking credit_checking --bug 4582292
1687: , cu.credit_usage_rule_set_id
1688: FROM hz_customer_profiles cp
1689: , hz_cust_profile_amts cpa
1690: , hz_credit_usages cu
1691: , hz_credit_usage_rules cur
1692: WHERE cp.site_use_id = p_entity_id
1693: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1694: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 1718: , hz_credit_usages cu

1714: , cp.credit_checking credit_checking --bug 4582292
1715: , cu.credit_usage_rule_set_id
1716: FROM hz_customer_profiles cp
1717: , hz_cust_profile_amts cpa
1718: , hz_credit_usages cu
1719: , hz_credit_usage_rules cur
1720: WHERE cp.site_use_id = p_entity_id
1721: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1722: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 1951: , hz_credit_usages cu

1947: , cu.credit_usage_rule_set_id
1948: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 1988: , hz_credit_usages cu

1984: , cu.credit_usage_rule_set_id
1985: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
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

Line 2195: , hz_credit_usages cu

2191: trx_limit
2192: , cu.credit_usage_rule_set_id
2193: FROM hz_credit_profiles cp
2194: , hz_credit_profile_amts cpa
2195: , hz_credit_usages cu
2196: , hz_credit_usage_rules cur
2197: WHERE cp.credit_profile_id = cpa.credit_profile_id
2198: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
2199: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 2223: , hz_credit_usages cu

2219: trx_limit
2220: , cu.credit_usage_rule_set_id
2221: FROM hz_credit_profiles cp
2222: , hz_credit_profile_amts cpa
2223: , hz_credit_usages cu
2224: , hz_credit_usage_rules cur
2225: WHERE cp.credit_profile_id = cpa.credit_profile_id
2226: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
2227: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 3052: FROM hz_credit_usages usg,

3048: --------------------------------------------------------
3049:
3050: CURSOR party_rule_set_csr IS
3051: SELECT credit_usage_rule_set_id
3052: FROM hz_credit_usages usg,
3053: hz_customer_profiles prf,
3054: hz_cust_profile_amts amt
3055: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3056: AND prf.cust_account_profile_id = amt.cust_account_profile_id

Line 3064: FROM hz_credit_usages usg,

3060: AND prf.party_id = p_entity_id ;
3061:
3062: CURSOR cust_rule_set_csr IS
3063: SELECT credit_usage_rule_set_id
3064: FROM hz_credit_usages usg,
3065: hz_customer_profiles prf,
3066: hz_cust_profile_amts amt
3067: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3068: AND prf.cust_account_profile_id = amt.cust_account_profile_id

Line 3075: FROM hz_credit_usages usg,

3071: AND prf.site_use_id IS NULL;
3072:
3073: CURSOR site_rule_set_csr IS
3074: SELECT credit_usage_rule_set_id
3075: FROM hz_credit_usages usg,
3076: hz_customer_profiles prf,
3077: hz_cust_profile_amts amt
3078: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3079: AND prf.cust_account_profile_id = amt.cust_account_profile_id

Line 3090: FROM hz_credit_usages usg,

3086: -- Default credit limit. --
3087: --------------------------------------------------------
3088: CURSOR dflt_rule_set_csr IS
3089: SELECT credit_usage_rule_set_id
3090: FROM hz_credit_usages usg,
3091: hz_credit_profiles prf,
3092: hz_credit_profile_amts amt
3093: WHERE usg.credit_profile_amt_id = amt.credit_profile_amt_id
3094: AND prf.credit_profile_id = amt.credit_profile_id