DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_CUS_ADDRESSES

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 561: jai_cmn_cus_addresses a

557: SELECT
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