APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 214: FROM hz_cust_accounts

210:
211: -- Segment and buying group has no acct info. use party_id for validation
212: CURSOR c_party_id(p_sold_to_org_id IN NUMBER) IS
213: SELECT party_id
214: FROM hz_cust_accounts
215: WHERE cust_account_id = p_sold_to_org_id;
216:
217: CURSOR c_customer_qualified(p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER, p_party_id NUMBER) IS
218: SELECT 'Y', object_type, qp_qualifier_group

Line 491: hz_cust_accounts cust,

487: CURSOR c_cust_number (p_header_id IN NUMBER) IS
488: SELECT cust.cust_account_id
489: FROM hz_cust_acct_sites_all acct_site,
490: hz_cust_site_uses_all site_use,
491: hz_cust_accounts cust,
492: oe_order_headers_all header
493: WHERE header.header_id = p_header_id
494: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
495: AND acct_site.cust_account_id = cust.cust_account_id

Line 912: FROM hz_cust_accounts

908: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_line_id);
909:
910: CURSOR party_id_csr(p_cust_account_id IN NUMBER) IS
911: SELECT party_id
912: FROM hz_cust_accounts
913: WHERE cust_account_id = p_cust_account_id;
914:
915: CURSOR party_site_id_csr(p_account_site_id IN NUMBER) IS
916: SELECT a.party_site_id

Line 946: hz_cust_accounts cust,

942: CURSOR c_cust_number (p_header_id IN NUMBER) IS
943: SELECT cust.cust_account_id
944: FROM hz_cust_acct_sites_all acct_site,
945: hz_cust_site_uses_all site_use,
946: hz_cust_accounts cust,
947: oe_order_headers_all header
948: WHERE header.header_id = p_header_id
949: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
950: AND acct_site.cust_account_id = cust.cust_account_id

Line 4729: hz_cust_accounts cust,

4725: CURSOR c_cust_number (p_header_id IN NUMBER) IS
4726: SELECT cust.cust_account_id
4727: FROM hz_cust_acct_sites_all acct_site,
4728: hz_cust_site_uses_all site_use,
4729: hz_cust_accounts cust,
4730: oe_order_headers_all header
4731: WHERE header.header_id = p_header_id
4732: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
4733: AND acct_site.cust_account_id = cust.cust_account_id