DBA Data[Home] [Help]

APPS.JAI_OM_TAX_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 2430: FROM JAI_CMN_CUS_ADDRESSES a, QP_LIST_LINES b, qp_pricing_attributes c

2426: CURSOR Get_Assessable_Value_Cur(p_customer_id Number,p_address_id Number, p_inventory_item_id Number,
2427: p_uom_code Varchar2, p_ordered_date date ) IS -- p_ordered_date variable name is misleading but the actual value it get is the SYSDATE
2428: SELECT b.operand list_price,
2429: c.product_uom_code list_price_uom_code
2430: FROM JAI_CMN_CUS_ADDRESSES a, QP_LIST_LINES b, qp_pricing_attributes c
2431: WHERE a.customer_id = p_customer_id
2432: AND a.address_id = p_address_id
2433: AND a.price_list_id = b.LIST_header_ID
2434: AND c.list_line_id = b.list_line_id