eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNTS

Line 1175: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

1171: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
1172: l_sob_id NUMBER;
1173:
1174: -- eBTax Changes
1175: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1176: l_ship_to_party_id hz_cust_accounts.party_id%type;
1177: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1178: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1179: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 1176: l_ship_to_party_id hz_cust_accounts.party_id%type;

1172: l_sob_id NUMBER;
1173:
1174: -- eBTax Changes
1175: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1176: l_ship_to_party_id hz_cust_accounts.party_id%type;
1177: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1178: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1179: l_bill_to_party_id hz_cust_accounts.party_id%type;
1180: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 1178: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

1174: -- eBTax Changes
1175: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1176: l_ship_to_party_id hz_cust_accounts.party_id%type;
1177: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1178: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1179: l_bill_to_party_id hz_cust_accounts.party_id%type;
1180: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
1181: l_org_id NUMBER;
1182: -- l_legal_entity_id NUMBER;

Line 1179: l_bill_to_party_id hz_cust_accounts.party_id%type;

1175: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1176: l_ship_to_party_id hz_cust_accounts.party_id%type;
1177: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1178: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1179: l_bill_to_party_id hz_cust_accounts.party_id%type;
1180: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
1181: l_org_id NUMBER;
1182: -- l_legal_entity_id NUMBER;
1183:

Line 1192: HZ_CUST_ACCOUNTS_ALL cust_Acct

1188: site_use.org_id
1189: FROM
1190: HZ_CUST_SITE_USES_ALL site_use,
1191: HZ_CUST_ACCT_SITES_ALL acct_site,
1192: HZ_CUST_ACCOUNTS_ALL cust_Acct
1193: WHERE site_use.site_use_id = p_site_org_id
1194: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1195: and acct_site.cust_account_id = cust_acct.cust_account_id;
1196: