APPS.JAI_AR_SUP_TRX_PKG dependencies on HZ_CUST_SITE_USES_ALL

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

611: AND b.list_header_id = PRICE_LIST
612: AND c.list_line_id = b.list_line_id
613: AND NVL(TRUNC(b.end_date_active),TRUNC(SYSDATE)) >= TRUNC(TRDATE);
614: -- Till Here
615: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
616: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
617: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
618: FROM HZ_CUST_SITE_USES_ALL A,
619: OE_ORDER_LINES_ALL B

Line 618: FROM HZ_CUST_SITE_USES_ALL A,

614: -- Till Here
615: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
616: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
617: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
618: FROM HZ_CUST_SITE_USES_ALL A,
619: OE_ORDER_LINES_ALL B
620: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
621: AND B.LINE_ID = PICKING_ID;
622: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */

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

618: FROM HZ_CUST_SITE_USES_ALL A,
619: OE_ORDER_LINES_ALL B
620: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
621: AND B.LINE_ID = PICKING_ID;
622: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
623: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS
624: SELECT CUST_ACCT_SITE_ID ADDRESS_ID
625: FROM HZ_CUST_SITE_USES_ALL
626: WHERE SITE_USE_ID = p_ship_to_site_id;

Line 625: FROM HZ_CUST_SITE_USES_ALL

621: AND B.LINE_ID = PICKING_ID;
622: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
623: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS
624: SELECT CUST_ACCT_SITE_ID ADDRESS_ID
625: FROM HZ_CUST_SITE_USES_ALL
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

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

1983: b.supp_inv_type,
1984: a.description,
1985: c.salesrep_iD,
1986: D.SALES_CREDIT_TYPE_ID;
1987: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287 */
1988: cursor get_address(site_id number) is
1989: select cust_acct_site_id address_id
1990: from hz_cust_site_uses_all
1991: where site_use_id = site_id;

Line 1990: from hz_cust_site_uses_all

1986: D.SALES_CREDIT_TYPE_ID;
1987: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287 */
1988: cursor get_address(site_id number) is
1989: select cust_acct_site_id address_id
1990: from hz_cust_site_uses_all
1991: where site_use_id = site_id;
1992:
1993: cursor GET_SUPP_INV_LINES(INV NUMBER,TYPE VARCHAR2) IS
1994: SELECT K.customer_trx_line_id,