DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 630: FROM JAI_CMN_CUS_ADDRESSES

626: WHERE SITE_USE_ID = p_ship_to_site_id;
627:
628: CURSOR GET_ASSESS_PRICE(ADDRESS NUMBER,INO1 NUMBER) IS
629: SELECT PRICE_LIST_ID
630: FROM JAI_CMN_CUS_ADDRESSES
631: WHERE ADDRESS_ID = NVL(ADDRESS,0)
632: AND CUSTOMER_ID = INO1;
633:
634: CURSOR GET_ASSESSABLE_PRICE_LIST(v_cust_id number) IS

Line 636: FROM JAI_CMN_CUS_ADDRESSES

632: AND CUSTOMER_ID = INO1;
633:
634: CURSOR GET_ASSESSABLE_PRICE_LIST(v_cust_id number) IS
635: SELECT PRICE_LIST_ID
636: FROM JAI_CMN_CUS_ADDRESSES
637: WHERE ADDRESS_ID = 0
638: AND CUSTOMER_ID = v_cust_id;
639:
640: CURSOR GET_ASSESS_LIST (INVENT NUMBER,UNT VARCHAR2 ,NEW_NO NUMBER, ADATE DATE) IS