APPS.JMF_SHIKYU_GRP SQL Statements

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

Line: 149

	SELECT mip.subcontracting_type, jso.oem_organization_id
	INTO l_subcontracting_type , l_oem_organization_id
	FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso
	 WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
	  AND jso.oem_organization_id = mip.from_organization_id
	  AND jso.tp_organization_id = mip.to_organization_id;

Line: 168

	   SELECT purchase_price_var_account
	   INTO l_ppv_account
	  FROM mtl_parameters
	 WHERE organization_id = l_oem_organization_id ;

Line: 179

    SELECT mip.shikyu_oem_var_account_id
    INTO   x_variance_account
    FROM   mtl_interorg_parameters mip,
          jmf_subcontract_orders jso
    WHERE  jso.subcontract_po_shipment_id = p_po_shipment_id
    AND    jso.oem_organization_id = mip.from_organization_id
    AND    jso.tp_organization_id = mip.to_organization_id;

Line: 307

  SELECT nvl(outsourced_assembly, 2)
  INTO   l_outsourced_assembly
  FROM   po_line_locations_all poll
  WHERE  poll.line_location_id = p_po_shipment_id;

Line: 329

      SELECT jso.oem_organization_id
       INTO l_oem_org_id
      FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso
      WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
      AND jso.oem_organization_id = mip.from_organization_id
      AND jso.tp_organization_id = mip.to_organization_id;

Line: 452

  SELECT nvl(trading_partner_org_flag, 'N')
  INTO   x_is_tp_org_flag
  FROM   MTL_PARAMETERS
  WHERE  organization_id = p_organization_id;

Line: 586

  SELECT DISTINCT NVL(plla.outsourced_assembly, 2)
  INTO   l_outsourced_assembly
  FROM   ap_invoice_distributions_all apd,
         po_distributions_all pda,
         po_line_locations_all plla
  WHERE  apd.po_distribution_id = pda.po_distribution_id
  AND    pda.line_location_id = plla.line_location_id
  AND    apd.invoice_id = p_ap_invoice_id
  AND    apd.distribution_line_number =
           (SELECT MIN(distribution_line_number)
            FROM   ap_invoice_distributions_all
            WHERE  invoice_id = p_ap_invoice_id);

Line: 750

  SELECT count('x')
  INTO   l_shikyu_enabled_so_line_count
  FROM   dual
  WHERE  exists
  (SELECT 'X'
   FROM    oe_order_lines_all oola,
           mtl_system_items_b msib,
           jmf_shikyu_replenishments jsr
   WHERE   oola.inventory_item_id = msib.inventory_item_id
   AND     msib.organization_id = jsr.oem_organization_id
   AND     msib.subcontracting_component in (1, 2)
   AND     jsr.replenishment_so_line_id = oola.line_id
   AND     jsr.replenishment_so_line_id IN
           (SELECT reference_line_id
            FROM   oe_order_lines_all
            WHERE  line_id = p_sales_order_line_id
           )
  );

Line: 891

  SELECT msib.outsourced_assembly
  INTO   l_ship_to_org_item_osa_flag
  FROM   mtl_system_items_b msib
  WHERE  msib.inventory_item_id = p_inventory_item_id
  AND    msib.organization_id = p_ship_to_organization_id;

Line: 909

    SELECT DISTINCT hoi.organization_id,
                    msib.outsourced_assembly
    INTO   l_tp_organization_id,
           l_tp_org_item_osa_flag
    FROM   HR_ORGANIZATION_INFORMATION hoi,
           MTL_SYSTEM_ITEMS_B msib
    WHERE  hoi.org_information_context = 'Customer/Supplier Association'
    AND    hoi.org_information3 = p_vendor_id
    AND    hoi.org_information4 = p_vendor_site_id
    AND    msib.organization_id = hoi.organization_id
    AND    msib.inventory_item_id = p_inventory_item_id;

Line: 1071

  SELECT outsourced_assembly, subcontracting_component
  INTO   X_outsourced_assembly, x_subcontracting_component
  FROM   mtl_system_items_b
  WHERE  organization_id = p_organization_id
  AND    inventory_item_id = p_item_id;

Line: 1175

	SELECT mip.subcontracting_type
	INTO l_subcontracting_type
	FROM mtl_interorg_parameters  mip
	WHERE mip.from_organization_id = p_oem_org_id
	AND mip.to_organization_id = p_mp_org_id;