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.

APPS.JAI_GST_GENERAL_PKG dependencies on QP_LIST_HEADERS

Line 127: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

123: nvl(b.start_date_active, p_ordered_date) AND
124: nvl(b.end_date_active, SYSDATE)
125: AND EXISTS
126: (SELECT 1
127: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
128: WHERE qlh.list_header_id = b.list_header_id
129: AND a.customer_id = p_party_id
130: AND a.address_id = p_address_id
131: AND a.Gst_Assessable_Price = b.LIST_header_ID

Line 146: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

142: AND trunc(nvl(b.end_date_active, SYSDATE)) >=
143: trunc(p_ordered_date)
144: AND EXISTS
145: (SELECT 1
146: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
147: WHERE a.customer_id = p_party_id
148: AND a.address_id = p_address_id
149: AND qlh.list_header_id = b.list_header_id
150: AND a.Gst_Assessable_Price = b.list_header_id

Line 164: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

160: AND c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id)
161: AND NVL(b.end_date_active, SYSDATE) >= p_ordered_date
162: AND EXISTS
163: (SELECT 1
164: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
165: WHERE a.customer_id = p_party_id
166: AND a.address_id = p_address_id
167: AND qlh.list_header_id = b.list_header_id
168: AND a.Gst_Assessable_Price = b.LIST_header_ID