APPS.JAI_JMCR_TRIGGER_PKG SQL Statements

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

Line: 42

                SELECT source_header_id, delivery_detail_id
                FROM wsh_delivery_details
                WHERE delivery_detail_id = pr_new.ref_line_id;

Line: 47

                SELECT NVL(org_id,0), ORGANIZATION_ID
                FROM wsh_delivery_details
                WHERE delivery_detail_id  = p_picking_header_id;

Line: 54

                SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,
                NVL(conversion_rate_date,ordered_date) conversion_date
                FROM oe_order_headers_all
                WHERE header_id = p_order_header_id;

Line: 64

    SELECT set_of_books_id
    FROM org_organization_definitions
    WHERE nvl(operating_unit,0) = p_org_id
    AND organization_id = p_warehouse_id;

Line: 70

                select source_line_id
                from wsh_delivery_details
                where delivery_detail_id =pr_new.ref_line_id;

Line: 75

                select bill_to_customer_id
                from ra_customer_trx_all
                where customer_trx_id in (select customer_trx_id from ra_customer_trx_lines_all
                        where customer_trx_line_id =pr_new.ref_line_id);

Line: 81

                SELECT sum(a.tax_amount) tax_amount
                FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
                WHERE a.tax_id = b.tax_id
                AND a.link_to_cust_trx_line_id = v_ref_line
                AND b.tax_type NOT IN (
          jai_constants.tax_type_tds ,
          jai_constants.tax_type_modvat_recovery);

Line: 150

        UPDATE  JAI_AR_TRX_LINES
        SET   matched_quantity = nvl(matched_quantity,0) + v_quantity
        WHERE Customer_Trx_Line_Id = v_ref_line;

Line: 162

      UPDATE JAI_AR_TRX_LINES
      SET tax_amount = rec.tax_amount,
                  total_amount = line_amount + rec.tax_amount
      WHERE Customer_Trx_Line_Id = v_ref_line;

Line: 211

    SELECT source_header_id, delivery_detail_id
    FROM   wsh_delivery_details
    WHERE  delivery_detail_id = pr_new.ref_line_id;

Line: 217

    SELECT NVL(org_id,0), ORGANIZATION_ID
    FROM wsh_delivery_details
    WHERE delivery_detail_id = p_picking_header_id;

Line: 222

    SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,
    NVL(conversion_rate_date,ordered_date) conversion_date
    FROM oe_order_headers_all
    WHERE header_id = p_order_header_id;

Line: 233

  cursor line is select source_line_id
    from wsh_delivery_details
    where delivery_detail_id =pr_new.ref_line_id;

Line: 239

  select SOLD_TO_ORG_ID
  from oe_order_headers_all
  where header_id in (select source_header_id
      from wsh_delivery_details
      where delivery_detail_id =pr_new.ref_line_id );

Line: 246

    SELECT set_of_books_id
    FROM org_organization_definitions
    WHERE nvl(operating_unit,0) = p_org_id
    AND organization_id = p_warehouse_id;