APPS.JAI_AR_SUP_TRX_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 687: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */

683: AND b.list_header_id = PRICE_LIST
684: AND c.list_line_id = b.list_line_id
685: AND NVL(TRUNC(b.end_date_active),TRUNC(SYSDATE)) >= TRUNC(TRDATE);
686: -- Till Here
687: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
688: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
689: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
690: FROM HZ_CUST_SITE_USES_ALL A,
691: OE_ORDER_LINES_ALL B

Line 690: FROM HZ_CUST_SITE_USES_ALL A,

686: -- Till Here
687: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
688: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
689: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
690: FROM HZ_CUST_SITE_USES_ALL A,
691: OE_ORDER_LINES_ALL B
692: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
693: AND B.LINE_ID = PICKING_ID;
694: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */

Line 694: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */

690: FROM HZ_CUST_SITE_USES_ALL A,
691: OE_ORDER_LINES_ALL B
692: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
693: AND B.LINE_ID = PICKING_ID;
694: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
695: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS
696: SELECT CUST_ACCT_SITE_ID ADDRESS_ID
697: FROM HZ_CUST_SITE_USES_ALL
698: WHERE SITE_USE_ID = p_ship_to_site_id;

Line 697: FROM HZ_CUST_SITE_USES_ALL

693: AND B.LINE_ID = PICKING_ID;
694: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
695: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS
696: SELECT CUST_ACCT_SITE_ID ADDRESS_ID
697: FROM HZ_CUST_SITE_USES_ALL
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

Line 2116: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287 */

2112: b.supp_inv_type,
2113: a.description,
2114: c.salesrep_iD,
2115: D.SALES_CREDIT_TYPE_ID;
2116: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287 */
2117: cursor get_address(site_id number) is
2118: select cust_acct_site_id address_id
2119: from hz_cust_site_uses_all
2120: where site_use_id = site_id;

Line 2119: from hz_cust_site_uses_all

2115: D.SALES_CREDIT_TYPE_ID;
2116: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287 */
2117: cursor get_address(site_id number) is
2118: select cust_acct_site_id address_id
2119: from hz_cust_site_uses_all
2120: where site_use_id = site_id;
2121:
2122: cursor GET_SUPP_INV_LINES(INV NUMBER,TYPE VARCHAR2) IS
2123: SELECT K.customer_trx_line_id,