DBA Data[Home] [Help]

APPS.JAI_OM_UTILS_PKG dependencies on QP_LIST_HEADERS_B

Line 161: qp_list_headers_b qlhb /* Added for bug#8844209 */

157: FROM
158: JAI_CMN_CUS_ADDRESSES a,
159: qp_list_lines b,
160: qp_pricing_attributes c ,
161: qp_list_headers_b qlhb /* Added for bug#8844209 */
162: WHERE
163: a.customer_id = p_customer_id AND
164: a.address_id = p_address_id AND
165: a.price_list_id = b.LIST_header_ID AND

Line 195: qp_list_headers_b qlhb /* Added for bug#8844209 */

191: FROM
192: JAI_CMN_CUS_ADDRESSES a,
193: qp_list_lines b,
194: qp_pricing_attributes c,
195: qp_list_headers_b qlhb /* Added for bug#8844209 */
196: WHERE
197: a.customer_id = p_customer_id AND
198: a.address_id = p_address_id AND
199: a.price_list_id = b.list_header_id AND

Line 224: qp_list_headers_b qlhb /* Added for bug#8844209 */

220: FROM
221: JAI_CMN_CUS_ADDRESSES a,
222: qp_list_lines b,
223: qp_pricing_attributes c,
224: qp_list_headers_b qlhb /* Added for bug#8844209 */
225: WHERE
226: a.customer_id = p_customer_id AND
227: a.address_id = p_address_id AND
228: a.price_list_id = b.LIST_header_ID AND

Line 287: qp_list_headers_b qlhb /* Added for bug#8844209 */

283: FROM
284: jai_cmn_cus_addresses a
285: , qp_list_lines b
286: , qp_pricing_attributes c ,
287: qp_list_headers_b qlhb /* Added for bug#8844209 */
288: WHERE a.customer_id = pn_party_id
289: AND a.address_id = pn_address_id
290: AND a.price_list_id = b.list_header_id
291: AND c.list_line_id = b.list_line_id

Line 323: qp_list_headers_b qlhb /* Added for bug#8844209 */

319: FROM
320: jai_cmn_cus_addresses a
321: , qp_list_lines b
322: , qp_pricing_attributes c ,
323: qp_list_headers_b qlhb /* Added for bug#8844209 */
324: WHERE a.customer_id = pn_party_id
325: AND a.address_id = pn_address_id
326: AND a.price_list_id = b.list_header_id
327: AND c.list_line_id = b.list_line_id

Line 358: qp_list_headers_b qlhb /* Added for bug#8844209 */

354: FROM
355: jai_cmn_cus_addresses a
356: , qp_list_lines b
357: , qp_pricing_attributes c ,
358: qp_list_headers_b qlhb /* Added for bug#8844209 */
359: WHERE a.customer_id = pn_party_id
360: AND a.address_id = pn_address_id
361: AND a.price_list_id = b.list_header_id
362: AND c.list_line_id = b.list_line_id