DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on QP_LIST_LINES

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

522:
523: CURSOR c_get_assessable_value(p_customer_id NUMBER, p_address_id NUMBER,
524: p_inventory_item_id VARCHAR2, p_uom_code VARCHAR2, p_ordered_date DATE )IS
525: SELECT b.operand list_price
526: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
527: WHERE a.customer_id = p_customer_id
528: AND a.address_id = p_address_id
529: AND a.price_list_id = b.list_header_id
530: AND c.list_line_id = b.list_line_id

Line 562: , qp_list_lines b

558: b.operand list_price
559: --, c.product_uom_code list_price_uom_code
560: FROM
561: jai_cmn_cus_addresses a
562: , qp_list_lines b
563: , qp_pricing_attributes c
564: WHERE a.customer_id = pn_party_id
565: AND a.address_id = pn_address_id
566: AND a.price_list_id = b.list_header_id

Line 984: FROM qp_List_Lines_v

980: AND Vendor_Site_Id = p_vendor_site_id;
981:
982: CURSOR c_get_assessable_value(p_price_list_id IN NUMBER, p_inv_item_id IN NUMBER, p_line_uom IN VARCHAR2) IS
983: SELECT operand
984: FROM qp_List_Lines_v
985: WHERE list_header_id = p_price_list_id
986: AND product_Id = p_inv_item_id
987: AND product_uom_code = p_line_uom
988: AND NVL( start_date_active, v_today - 1 ) <= v_today

Line 1016: qp_list_lines b

1012: IS
1013: SELECT
1014: b.operand list_price
1015: FROM
1016: qp_list_lines b
1017: , qp_pricing_attributes c
1018: WHERE b.list_header_id = pn_price_list_id
1019: AND c.list_line_id = b.list_line_id
1020: AND c.product_uom_code = pv_uom_code