DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on HZ_PARTIES

Line 1972: FROM hz_parties a,

1968: st.meaning status,
1969: ore.attribute_value cc_no,
1970: ore.cc_expiry_date cc_exp_date,
1971: (SELECT party_name
1972: FROM hz_parties a,
1973: hz_cust_accounts b
1974: WHERE a.party_id = b.party_id
1975: AND b.cust_account_id = cust_acct_id) party_name
1976: FROM oks_rule_error ore,

Line 1998: FROM hz_parties a,

1994: st.meaning status,
1995: ore.attribute_value cc_no,
1996: ore.cc_expiry_date cc_exp_date,
1997: (SELECT party_name
1998: FROM hz_parties a,
1999: hz_cust_accounts b
2000: WHERE a.party_id = b.party_id
2001: AND b.cust_account_id = cust_acct_id) party_name
2002: FROM oks_rule_error ore,

Line 2024: FROM hz_parties a,

2020: st.meaning status,
2021: ore.attribute_value cc_no,
2022: ore.cc_expiry_date cc_exp_date,
2023: (SELECT party_name
2024: FROM hz_parties a,
2025: hz_cust_accounts b
2026: WHERE a.party_id = b.party_id
2027: AND b.cust_account_id = lc.cust_acct_id) party_name,
2028: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',

Line 2067: FROM hz_parties a,

2063: st.meaning status,
2064: ore.attribute_value cc_no,
2065: ore.cc_expiry_date cc_exp_date,
2066: (SELECT party_name
2067: FROM hz_parties a,
2068: hz_cust_accounts b
2069: WHERE a.party_id = b.party_id
2070: AND b.cust_account_id = lc.cust_acct_id) party_name,
2071: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',