DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_CMN_CUS_ADDRESSES

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

258:
259: CURSOR get_assessable_value_cur(p_customer_id NUMBER, p_address_id NUMBER,
260: p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE )IS
261: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
262: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
263: WHERE A.customer_id = p_customer_id
264: AND A.address_id = p_address_id
265: AND A.price_list_id = b.LIST_header_ID
266: AND c.list_line_id = b.list_line_id

Line 3093: FROM JAI_CMN_CUS_ADDRESSES a,

3089: p_uom_code VARCHAR2,
3090: p_ordered_date DATE )IS
3091: SELECT b.operand list_price,
3092: c.product_uom_code list_price_uom_code
3093: FROM JAI_CMN_CUS_ADDRESSES a,
3094: QP_LIST_LINES b,
3095: qp_pricing_attributes c
3096: WHERE a.customer_id = p_customer_id
3097: AND a.address_id = p_address_id