DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on QP_LIST_LINES

Line 281: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c

277:
278: CURSOR get_assessable_value_cur(p_customer_id NUMBER, p_address_id NUMBER,
279: p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE )IS
280: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
281: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
282: WHERE A.customer_id = p_customer_id
283: AND A.address_id = p_address_id
284: AND A.price_list_id = b.LIST_header_ID
285: AND c.list_line_id = b.list_line_id

Line 4996: QP_LIST_LINES b,

4992: p_ordered_date DATE )IS
4993: SELECT b.operand list_price,
4994: c.product_uom_code list_price_uom_code
4995: FROM JAI_CMN_CUS_ADDRESSES a,
4996: QP_LIST_LINES b,
4997: qp_pricing_attributes c
4998: WHERE a.customer_id = p_customer_id
4999: AND a.address_id = p_address_id
5000: AND a.price_list_id = b.LIST_header_ID