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_OM_UTILS_PKG dependencies on QP_PRICING_ATTRIBUTES

Line 126: qp_pricing_attributes c

122: c.product_uom_code list_price_uom_code
123: FROM
124: JAI_CMN_CUS_ADDRESSES a,
125: qp_list_lines b,
126: qp_pricing_attributes c
127: WHERE
128: a.customer_id = p_customer_id AND
129: a.address_id = p_address_id AND
130: a.price_list_id = b.LIST_header_ID AND

Line 155: qp_pricing_attributes c

151: c.product_uom_code list_price_uom_code
152: FROM
153: JAI_CMN_CUS_ADDRESSES a,
154: qp_list_lines b,
155: qp_pricing_attributes c
156: WHERE
157: a.customer_id = p_customer_id AND
158: a.address_id = p_address_id AND
159: a.price_list_id = b.list_header_id AND

Line 180: qp_pricing_attributes c

176: c.product_uom_code list_price_uom_code
177: FROM
178: JAI_CMN_CUS_ADDRESSES a,
179: qp_list_lines b,
180: qp_pricing_attributes c
181: WHERE
182: a.customer_id = p_customer_id AND
183: a.address_id = p_address_id AND
184: a.price_list_id = b.LIST_header_ID AND

Line 190: v_primary_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249

186: c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id) AND
187: (b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
188: --NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
189:
190: v_primary_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
191: v_other_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
192:
193: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
194: v_address_id NUMBER;

Line 191: v_other_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249

187: (b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
188: --NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
189:
190: v_primary_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
191: v_other_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
192:
193: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
194: v_address_id NUMBER;
195: v_assessable_value NUMBER;