DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 702: FROM JAI_CMN_CUS_ADDRESSES

698: WHERE SITE_USE_ID = p_ship_to_site_id;
699:
700: CURSOR GET_ASSESS_PRICE(ADDRESS NUMBER,INO1 NUMBER) IS
701: SELECT PRICE_LIST_ID
702: FROM JAI_CMN_CUS_ADDRESSES
703: WHERE ADDRESS_ID = NVL(ADDRESS,0)
704: AND CUSTOMER_ID = INO1;
705:
706: CURSOR GET_ASSESSABLE_PRICE_LIST(v_cust_id number) IS

Line 708: FROM JAI_CMN_CUS_ADDRESSES

704: AND CUSTOMER_ID = INO1;
705:
706: CURSOR GET_ASSESSABLE_PRICE_LIST(v_cust_id number) IS
707: SELECT PRICE_LIST_ID
708: FROM JAI_CMN_CUS_ADDRESSES
709: WHERE ADDRESS_ID = 0
710: AND CUSTOMER_ID = v_cust_id;
711:
712: CURSOR GET_ASSESS_LIST (INVENT NUMBER,UNT VARCHAR2 ,NEW_NO NUMBER, ADATE DATE) IS