APPS.IBE_WORKFLOW_PVT dependencies on HZ_CUST_ACCOUNTS

Line 174: hz_cust_accounts sold_to_account,

170: invaddr.country bill_to_country,
171: oh.transactional_curr_code
172: from oe_order_headers_all oh,
173: hz_parties sold_to_party,
174: hz_cust_accounts sold_to_account,
175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,

Line 2757: from hz_cust_accounts a,

2753: p.person_first_name,
2754: p.person_last_name,
2755: p.person_middle_name
2756:
2757: from hz_cust_accounts a,
2758: oe_order_headers_all o,
2759: hz_parties p
2760: where o.sold_to_org_id = a.cust_account_id
2761: and a.party_id = p.party_id

Line 8674: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS

8670: AND quote_line_id IS NULL
8671: AND rownum = 1;
8672:
8673:
8674: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8675: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8676: FROM hz_cust_accounts hc, hz_parties hp
8677: WHERE cust_account_id = p_cust_account_id
8678: AND hc.party_id = hp.party_id;

Line 8676: FROM hz_cust_accounts hc, hz_parties hp

8672:
8673:
8674: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8675: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8676: FROM hz_cust_accounts hc, hz_parties hp
8677: WHERE cust_account_id = p_cust_account_id
8678: AND hc.party_id = hp.party_id;
8679:
8680: l_sold_contact_party_id Number;

Line 8745: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id) LOOP

8741: END LOOP;
8742:
8743:
8744: If l_sold_contact_party_id is null Then
8745: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id) LOOP
8746: l_contact_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8747: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
8748: End Loop;
8749: End If;

Line 8785: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(g_quote_header_rec.invoice_to_cust_account_id,g_quote_header_rec.cust_account_id)) LOOP

8781:
8782:
8783: /* Bill Customer Info. From Invoice_To_Cust_Account_ID */
8784:
8785: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(g_quote_header_rec.invoice_to_cust_account_id,g_quote_header_rec.cust_account_id)) LOOP
8786: l_bill_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
8787: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8788: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
8789: End Loop;

Line 8881: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(l_ship_to_cust_account_id,g_quote_header_rec.cust_account_id)) LOOP

8877:
8878:
8879:
8880:
8881: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(l_ship_to_cust_account_id,g_quote_header_rec.cust_account_id)) LOOP
8882: l_ship_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
8883: l_ship_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8884: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
8885: End Loop;