APPS.JAI_OM_UTILS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

  SELECT line_id,ordered_quantity,order_quantity_uom,inventory_item_id
    FROM oe_order_lines_all
   WHERE line_id = il6;

Line: 43

  CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
    FROM oe_order_lines_all
   WHERE ato_line_id = ln_id;

Line: 47

  CURSOR n_lst_price(id number,unt varchar2) is select list_price
    FROM so_price_list_lines_115
   WHERE inventory_item_id = id
     AND unit_code = unt
     AND price_list_id = new_list;

Line: 103

    SELECT NVL(cust_acct_site_id , 0) address_id
    FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
    WHERE A.site_use_id = p_ship_to_site_use_id;  /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line: 120

    SELECT
            b.operand list_price,
            c.product_uom_code list_price_uom_code
    FROM
            JAI_CMN_CUS_ADDRESSES a,
            qp_list_lines b,
            qp_pricing_attributes c
    WHERE
            a.customer_id           = p_customer_id                                 AND
            a.address_id            = p_address_id                                  AND
            a.price_list_id         = b.LIST_header_ID                              AND
            c.list_line_id          = b.list_line_id                                AND
            c.product_attr_value    = to_char(p_inventory_item_id)                  AND
            c.product_uom_code      = p_uom_code                                    AND
            p_ordered_date          BETWEEN nvl( start_date_active, p_ordered_date) AND
                                            nvl( end_date_active, SYSDATE);

Line: 149

     SELECT
             b.operand list_price,
             c.product_uom_code list_price_uom_code
     FROM
             JAI_CMN_CUS_ADDRESSES a,
             qp_list_lines b,
             qp_pricing_attributes c
     WHERE
             a.customer_id                           = p_customer_id                      AND
             a.address_id                            = p_address_id                       AND
             a.price_list_id                         = b.list_header_id                   AND
             c.list_line_id                          = b.list_line_id                     AND
             c.product_attr_value                    = to_char(p_inventory_item_id)       AND
             trunc(nvl(b.end_date_active,sysdate))   >= trunc(p_ordered_date)             AND
	     primary_uom_flag               ='Y'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line: 174

     SELECT
             b.operand list_price,
             c.product_uom_code list_price_uom_code
     FROM
             JAI_CMN_CUS_ADDRESSES a,
             qp_list_lines b,
             qp_pricing_attributes c
     WHERE
             a.customer_id                  = p_customer_id                  AND
             a.address_id                   = p_address_id                   AND
             a.price_list_id                = b.LIST_header_ID               AND
             c.list_line_id                 = b.list_line_id                 AND
             c.PRODUCT_ATTR_VALUE           = TO_CHAR(p_inventory_item_id)   AND
	     (b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line: 478

  SELECT LINE_ID,ORDERED_QUANTITY,ORDER_QUANTITY_UOM,INVENTORY_ITEM_ID
    FROM OE_ORDER_LINES_ALL
   WHERE LINE_ID = IL6;

Line: 483

  SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM
    FROM OE_ORDER_LINES_ALL
   WHERE ATO_LINE_ID = LN_ID;

Line: 488

  SELECT LIST_PRICE
    FROM SO_PRICE_LIST_LINES_115
   WHERE INVENTORY_ITEM_ID = INVENT
     AND UNIT_CODE = UNT
     AND PRICE_LIST_ID = NEW_NO
     AND SYSDATE BETWEEN
     NVL(START_DATE_ACTIVE,SYSDATE)
     AND NVL(END_DATE_ACTIVE,SYSDATE);

Line: 600

   SELECT
                        '1'
   FROM
                        JAI_OM_OE_SO_TAXES      tl,
                        JAI_CMN_TAXES_ALL         tc
   WHERE
                        tc.tax_type = jai_constants.tax_type_modvat_recovery AND /*--'Modvat Recovery'  Ramananda for removal of SQL LITERALs :bug#4428980*/
                        tc.tax_id   = tl.tax_id          AND
                        tl.line_id  = p_line_id ;