APPS.JMF_SHIKYU_ONT_PVT SQL Statements

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

Line: 156

  SELECT NVL(intransit_time,0)
  FROM   mtl_interorg_ship_methods
  WHERE  from_organization_id = p_oem_organization_id
  AND    to_organization_id   = p_tp_organization_id
  AND    default_flag         =1;

Line: 190

    SELECT NVL(plla.need_by_date, plla.promised_date)
         , jso.osa_item_id
    INTO
      l_need_by_date
    , l_osa_item_id
    FROM
      jmf_subcontract_orders jso,
      po_line_locations_all  plla
    WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
    AND   plla.line_location_id = jso.subcontract_po_shipment_id;

Line: 374

  SELECT distinct project_id
       , task_id
  FROM   po_distributions_all
  WHERE  line_location_id = p_replen_po_shipment_id
  AND    project_id IS NOT NULL;

Line: 431

      SELECT org_id
      INTO   l_org_id
      FROM   po_line_locations_all
      WHERE  line_location_id = p_replen_po_shipment_id;

Line: 442

                    , '>> ' || l_program ||': Org ID selected from PO_LINE_LOCATIONS_ALL = '
                      || l_org_id
             );

Line: 461

  SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
  INTO   l_client_info_org_id
  FROM   DUAL;

Line: 538

  SELECT TO_NUMBER(org_information1)
  INTO   l_header_rec.sold_to_org_id
  FROM   HR_ORGANIZATION_INFORMATION
  WHERE  organization_id = p_tp_organization_id
  AND    org_information_context = 'Customer/Supplier Association';

Line: 569

  SELECT site.site_use_id
  INTO   l_header_rec.invoice_to_org_id
  FROM   hz_cust_site_uses_all site,
         hz_cust_acct_sites_all acct_site
  WHERE  site.cust_acct_site_id = acct_site.cust_acct_site_id
  AND    site.site_use_code = 'BILL_TO'
  AND    site.org_id = acct_site.org_id
  AND    acct_site.cust_account_id = l_header_rec.sold_to_org_id
  AND    site.status = 'A';

Line: 591

  SELECT shikyu_default_order_type_id
  INTO   l_header_rec.order_type_id
  FROM   mtl_interorg_parameters
  WHERE  from_organization_id =  p_oem_organization_id
  AND    to_organization_id   =  p_tp_organization_id;

Line: 598

  SELECT default_outbound_line_type_id
  INTO   l_line_type_id
  FROM   oe_transaction_Types_all
  WHERE  transaction_type_id = l_header_rec.order_type_id;

Line: 617

      SELECT NVL(need_by_date, promised_date)
      INTO   l_replen_po_need_by_date
      FROM   po_line_locations_all
      WHERE  line_location_id = p_replen_po_shipment_id;

Line: 695

  SELECT primary_uom_code
  INTO   l_primary_uom_code
  FROM   mtl_system_items_b
  WHERE  inventory_item_id = p_item_id
  AND    organization_id   = p_oem_organization_id;

Line: 730

      SELECT muomvl.uom_code,
             plla.quantity
      INTO   l_price_list_uom,
             l_quantity
      FROM   po_line_locations_all plla,
             mtl_units_of_measure_vl muomvl
      WHERE  plla.line_location_id = p_replen_po_shipment_id
      AND    plla.unit_meas_lookup_code = muomvl.unit_of_measure;

Line: 825

      SELECT segment1
      INTO l_order_number
      FROM po_headers_all poh
      WHERE EXISTS
      (SELECT 1 FROM po_line_locations_all poll
       WHERE poll.line_location_id = p_subcontract_po_shipment_id
       AND poll.po_header_id = poh.po_header_id);

Line: 833

      SELECT segment1
      INTO l_sub_comp
      FROM mtl_system_items_b
      WHERE inventory_item_id = p_item_id
      AND organization_id = p_tp_organization_id ;

Line: 857

  SELECT unit_selling_price,
         price_list_id
  INTO   l_unit_price,
         l_price_list_id
  FROM   oe_order_lines_all
  WHERE  line_id = l_line_tbl(1).line_id;

Line: 881

  SELECT currency_code
  INTO   l_currency_code
  FROM   oe_price_lists
  WHERE  price_list_id = l_price_list_id;

Line: 905

    SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),
           operand
    INTO   l_price_list_uom,
           l_component_price
    FROM   qp_list_lines
    WHERE  list_header_id = l_price_list_id
    AND    qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id
    AND    l_ship_date BETWEEN
           NVL(start_date_active, l_ship_date - 1)
           AND
           NVL(end_date_active, l_ship_date + 1);

Line: 926

        UPDATE jmf_shikyu_components
        SET currency = l_currency_code
          , price_list_id = l_price_list_id
          , last_update_date = sysdate
          , last_updated_by = FND_GLOBAL.user_id
          , last_update_login = FND_GLOBAL.login_id
        WHERE  subcontract_po_shipment_id = p_subcontract_po_shipment_id
        AND    oem_organization_id = p_oem_organization_id
        AND    shikyu_component_id = p_item_id;

Line: 1048

      UPDATE jmf_shikyu_components
      SET primary_uom_price = l_unit_price
        , primary_uom = l_primary_uom_code
        , uom         = l_price_list_uom
        , currency    = l_currency_code
        , price_list_id = l_price_list_id
        , shikyu_component_price = l_component_price
        , last_update_date = sysdate
        , last_updated_by = FND_GLOBAL.user_id
        , last_update_login = FND_GLOBAL.login_id
      WHERE  subcontract_po_shipment_id = p_subcontract_po_shipment_id
      AND    oem_organization_id = p_oem_organization_id
      AND    shikyu_component_id = p_item_id;

Line: 1067

                      , '>> ' || l_program || ': Updated JMF_SHIKYU_COMPONENTS table'
                      );

Line: 1123

      SELECT concatenated_segments
      INTO   l_item_number
      FROM   MTL_SYSTEM_ITEMS_VL
      WHERE  organization_id = p_oem_organization_id
      AND    inventory_item_id = p_item_id;

Line: 1141

      SELECT concatenated_segments
      INTO   l_item_number
      FROM   MTL_SYSTEM_ITEMS_VL
      WHERE  organization_id = p_oem_organization_id
      AND    inventory_item_id = p_item_id;

Line: 1159

      SELECT concatenated_segments
      INTO   l_item_number
      FROM   MTL_SYSTEM_ITEMS_VL
      WHERE  organization_id = p_oem_organization_id
      AND    inventory_item_id = p_item_id;