APPS.IBE_WORKFLOW_PVT dependencies on HZ_CUST_ACCOUNTS

Line 164: hz_cust_accounts sold_to_account,

160: invaddr.country bill_to_country,
161: oh.transactional_curr_code
162: from oe_order_headers_all oh,
163: hz_parties sold_to_party,
164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,

Line 2667: from hz_cust_accounts a,

2663: p.person_first_name,
2664: p.person_last_name,
2665: p.person_middle_name
2666:
2667: from hz_cust_accounts a,
2668: oe_order_headers_all o,
2669: hz_parties p
2670: where o.sold_to_org_id = a.cust_account_id
2671: and a.party_id = p.party_id

Line 8579: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS

8575: AND quote_line_id IS NULL
8576: AND rownum = 1;
8577:
8578:
8579: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8580: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8581: FROM hz_cust_accounts hc, hz_parties hp
8582: WHERE cust_account_id = p_cust_account_id
8583: AND hc.party_id = hp.party_id;

Line 8581: FROM hz_cust_accounts hc, hz_parties hp

8577:
8578:
8579: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8580: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8581: FROM hz_cust_accounts hc, hz_parties hp
8582: WHERE cust_account_id = p_cust_account_id
8583: AND hc.party_id = hp.party_id;
8584:
8585: l_sold_contact_party_id Number;

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

8646: END LOOP;
8647:
8648:
8649: If l_sold_contact_party_id is null Then
8650: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id) LOOP
8651: l_contact_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8652: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
8653: End Loop;
8654: End If;

Line 8690: 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

8686:
8687:
8688: /* Bill Customer Info. From Invoice_To_Cust_Account_ID */
8689:
8690: 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
8691: l_bill_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
8692: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8693: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
8694: End Loop;

Line 8786: 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

8782:
8783:
8784:
8785:
8786: 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
8787: l_ship_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
8788: l_ship_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
8789: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
8790: End Loop;