APPS.OE_BULK_PROCESS_LINE dependencies on HZ_CUST_ACCOUNTS

Line 2264: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

2260: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
2261: l_sob_id NUMBER;
2262:
2263: -- eBTax Changes
2264: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2265: l_ship_to_party_id hz_cust_accounts.party_id%type;
2266: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2267: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2268: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 2265: l_ship_to_party_id hz_cust_accounts.party_id%type;

2261: l_sob_id NUMBER;
2262:
2263: -- eBTax Changes
2264: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2265: l_ship_to_party_id hz_cust_accounts.party_id%type;
2266: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2267: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2268: l_bill_to_party_id hz_cust_accounts.party_id%type;
2269: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 2267: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

2263: -- eBTax Changes
2264: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2265: l_ship_to_party_id hz_cust_accounts.party_id%type;
2266: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2267: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2268: l_bill_to_party_id hz_cust_accounts.party_id%type;
2269: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
2270: l_org_id NUMBER;
2271:

Line 2268: l_bill_to_party_id hz_cust_accounts.party_id%type;

2264: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2265: l_ship_to_party_id hz_cust_accounts.party_id%type;
2266: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2267: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2268: l_bill_to_party_id hz_cust_accounts.party_id%type;
2269: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
2270: l_org_id NUMBER;
2271:
2272: --PP Revenue Recognition

Line 2286: HZ_CUST_ACCOUNTS_ALL cust_Acct

2282: site_use.org_id
2283: FROM
2284: HZ_CUST_SITE_USES_ALL site_use,
2285: HZ_CUST_ACCT_SITES_ALL acct_site,
2286: HZ_CUST_ACCOUNTS_ALL cust_Acct
2287: WHERE site_use.site_use_id = p_site_org_id
2288: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
2289: and acct_site.cust_account_id = cust_acct.cust_account_id;
2290: