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.

[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 26: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

22: return boolean
23:
24: IS
25: ln_address_id NUMBER;
26: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
27:
28: CURSOR c_get_address is
29: SELECT hzcas.cust_acct_site_id
30: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas

Line 37: FROM JAI_CMN_CUS_ADDRESSES

33: AND hzcas.cust_account_id = pn_customer_id;
34:
35: CURSOR c_regno(pn_address_id NUMBER) IS
36: SELECT vat_Reg_no
37: FROM JAI_CMN_CUS_ADDRESSES
38: WHERE customer_id = pn_customer_id
39: AND address_id = pn_address_id;
40:
41: BEGIN

Line 970: from JAI_CMN_CUS_ADDRESSES

966: select list_price, unit_code
967: from so_price_list_lines
968: where price_list_id in
969: (select price_list_id
970: from JAI_CMN_CUS_ADDRESSES
971: where customer_id = p_customer_id
972: and address_id = p_address_id)
973: and inventory_item_id = p_inventory_item_id
974: and unit_code = v_uom_code