DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on QP_LIST_LINES

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

433:
434: CURSOR c_get_assessable_value(p_customer_id NUMBER, p_address_id NUMBER,
435: p_inventory_item_id VARCHAR2, p_uom_code VARCHAR2, p_ordered_date DATE )IS
436: SELECT b.operand list_price
437: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
438: WHERE a.customer_id = p_customer_id
439: AND a.address_id = p_address_id
440: AND a.price_list_id = b.list_header_id
441: AND c.list_line_id = b.list_line_id

Line 767: FROM qp_List_Lines_v

763: AND Vendor_Site_Id = p_vendor_site_id;
764:
765: CURSOR c_get_assessable_value(p_price_list_id IN NUMBER, p_inv_item_id IN NUMBER, p_line_uom IN VARCHAR2) IS
766: SELECT operand
767: FROM qp_List_Lines_v
768: WHERE list_header_id = p_price_list_id
769: AND product_Id = p_inv_item_id
770: AND product_uom_code = p_line_uom
771: AND NVL( start_date_active, v_today - 1 ) <= v_today