DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on HZ_CUST_ACCOUNTS

Line 2319: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

2315: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
2316: l_sob_id NUMBER;
2317:
2318: -- eBTax Changes
2319: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2320: l_ship_to_party_id hz_cust_accounts.party_id%type;
2321: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2322: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2323: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 2320: l_ship_to_party_id hz_cust_accounts.party_id%type;

2316: l_sob_id NUMBER;
2317:
2318: -- eBTax Changes
2319: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2320: l_ship_to_party_id hz_cust_accounts.party_id%type;
2321: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2322: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2323: l_bill_to_party_id hz_cust_accounts.party_id%type;
2324: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 2322: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

2318: -- eBTax Changes
2319: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2320: l_ship_to_party_id hz_cust_accounts.party_id%type;
2321: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2322: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2323: l_bill_to_party_id hz_cust_accounts.party_id%type;
2324: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
2325: l_org_id NUMBER;
2326:

Line 2323: l_bill_to_party_id hz_cust_accounts.party_id%type;

2319: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2320: l_ship_to_party_id hz_cust_accounts.party_id%type;
2321: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
2322: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
2323: l_bill_to_party_id hz_cust_accounts.party_id%type;
2324: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
2325: l_org_id NUMBER;
2326:
2327: --PP Revenue Recognition

Line 2341: HZ_CUST_ACCOUNTS_ALL cust_Acct

2337: site_use.org_id
2338: FROM
2339: HZ_CUST_SITE_USES_ALL site_use,
2340: HZ_CUST_ACCT_SITES_ALL acct_site,
2341: HZ_CUST_ACCOUNTS_ALL cust_Acct
2342: WHERE site_use.site_use_id = p_site_org_id
2343: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
2344: and acct_site.cust_account_id = cust_acct.cust_account_id;
2345: