APPS.OE_MARGIN_PVT SQL Statements

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

Line: 41

                 p_selected_records            Oe_Globals.Selected_Record_Tbl
                ,P_cost_level                  varchar2
)

is

l_request_rec      Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC;

Line: 66

                i := p_selected_records.first;

Line: 68

                   l_line_id := p_selected_records(i).id1;

Line: 69

                   l_org_id := p_selected_records(i).org_id;

Line: 76

                   i := p_selected_records.next(i);

Line: 83

               i := p_selected_records.first;

Line: 85

                  l_Header_id := p_selected_records(i).id1;

Line: 86

                  l_org_id := p_selected_records(i).org_id;

Line: 100

                  i := p_selected_records.next(i);

Line: 127

        SELECT ohr.HOLD_RELEASE_ID
          FROM OE_ORDER_HOLDS h,
               OE_HOLD_SOURCES s,
               oe_hold_releases ohr
         WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
           AND H.HEADER_ID = p_header_id
           AND H.LINE_ID IS NULL
           AND H.HOLD_RELEASE_ID IS NOT NULL
           AND S.HOLD_ID = p_hold_id
           AND S.HOLD_ENTITY_CODE = 'O'
           AND S.HOLD_ENTITY_ID = p_header_id
           AND S.RELEASED_FLAG ='Y'
           AND ohr.HOLD_RELEASE_ID = h.HOLD_RELEASE_ID
          ORDER BY ohr.creation_date DESC;

Line: 143

          SELECT ohr.HOLD_RELEASE_ID
          FROM OE_ORDER_HOLDS h,
               OE_HOLD_SOURCES s,
               oe_hold_releases ohr
         WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
           AND H.HEADER_ID = p_header_id
           AND H.LINE_ID = p_line_id
           AND H.HOLD_RELEASE_ID IS NOT NULL
           AND S.HOLD_ID = p_hold_id
           AND S.HOLD_ENTITY_CODE = 'O'
           AND S.HOLD_ENTITY_ID = p_header_id
           AND S.RELEASED_FLAG ='Y'
           AND ohr.HOLD_RELEASE_ID = h.HOLD_RELEASE_ID
          ORDER BY ohr.creation_date DESC;

Line: 167

       /* SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
        INTO l_hold_release_id
        FROM OE_ORDER_HOLDS h,
             OE_HOLD_SOURCES s
       WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
         AND H.HEADER_ID = p_header_id
         AND H.LINE_ID IS NULL
         AND H.HOLD_RELEASE_ID IS NOT NULL
         AND S.HOLD_ID = p_hold_id
         AND S.HOLD_ENTITY_CODE = 'O'
         AND S.HOLD_ENTITY_ID = p_header_id
         AND S.RELEASED_FLAG ='Y';

Line: 206

        /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
        INTO l_hold_release_id
        FROM OE_ORDER_HOLDS h,
             OE_HOLD_SOURCES s
       WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
         AND H.HEADER_ID = p_header_id
         AND H.LINE_ID = p_line_id
         AND H.HOLD_RELEASE_ID IS NOT NULL
         AND S.HOLD_ID = p_hold_id
         AND S.HOLD_ENTITY_CODE = 'O'
         AND S.HOLD_ENTITY_ID = p_header_id
         AND S.RELEASED_FLAG ='Y';

Line: 246

         select 'Y'
           into l_manual_hold_exists
           FROM OE_HOLD_RELEASES
          WHERE HOLD_RELEASE_ID = l_hold_release_id
            AND RELEASE_REASON_CODE <> 'PASS_MIN_MARGIN'
            AND CREATED_BY <> 1;

Line: 321

SELECT w.whse_code
     , s.orgn_code
FROM   mtl_parameters p
     , ic_whse_mst w
     , sy_orgn_mst s
     , gl_plcy_mst plcy
WHERE plcy.co_code            = s.co_code
AND   w.mtl_organization_id   = p.organization_id
AND   s.orgn_code             = w.orgn_code
AND   s.orgn_code             = p.process_orgn_code
AND   p.process_enabled_flag  ='Y'
AND   s.delete_mark           = 0
AND   w.delete_mark           = 0
AND   p.ORGANIZATION_ID       = p_organization_id
AND   rownum < 2; */

Line: 341

   SELECT POL.UNIT_PRICE
   FROM PO_LINES_ALL POL,
     OE_DROP_SHIP_SOURCES OEDSS
   WHERE OEDSS.LINE_ID = l_line_rec.line_id
   AND OEDSS.PO_RELEASE_ID IS NULL
   AND POL.PO_LINE_ID = OEDSS.PO_LINE_ID
   UNION
   SELECT PRL.UNIT_PRICE
   FROM PO_REQUISITION_LINES_ALL PRL,
     OE_DROP_SHIP_SOURCES OEDSS
   WHERE OEDSS.LINE_ID = l_line_rec.line_id
   AND OEDSS.PO_LINE_ID IS NULL
   AND PRL.REQUISITION_LINE_ID = OEDSS.REQUISITION_LINE_ID
   UNION
   SELECT POLL.PRICE_OVERRIDE UNIT_PRICE
   FROM PO_LINE_LOCATIONS_ALL POLL,
   OE_DROP_SHIP_SOURCES OEDSS
   WHERE OEDSS.LINE_ID = l_line_rec.line_id
   AND OEDSS.PO_LINE_ID IS NOT NULL
   AND POLL.LINE_LOCATION_ID = OEDSS.LINE_LOCATION_ID
   AND OEDSS.PO_RELEASE_ID IS NOT NULL;

Line: 445

      SELECT SET_OF_BOOKS_ID
        INTO l_set_of_books_id
        FROM ORG_ORGANIZATION_DEFINITIONS
       WHERE ORGANIZATION_ID =  G_SHIP_FROM_ORG_ID;

Line: 456

      SELECT Currency_Code
        INTO G_SOB_CURRENCY
        FROM OE_GL_SETS_OF_BOOKS_V
       WHERE SET_OF_BOOKS_ID = l_set_of_books_id;

Line: 504

   SELECT unit_price
   INTO   l_unit_cost
   FROM   oe_drop_ship_links_v
   WHERE  line_id = l_line_rec.line_id;

Line: 526

     select inventory_organization_id into l_inventory_org_id from financials_system_parameters;  --bug 2733946

Line: 528

     SELECT list_price_per_unit
     INTO   l_unit_cost
     FROM   mtl_system_items_kfv
     WHERE  inventory_item_id = nvl(l_line_rec.inventory_item_id,p_inventory_item_id)
     AND    organization_id   = l_inventory_org_id; --nvl(l_line_rec.ship_from_org_id,p_ship_from_org_id);

Line: 558

      SELECT NVL(default_cost_group_id,-1)
      INTO   l_cost_group_id
      FROM   mtl_parameters
      WHERE  organization_id = G_SHIP_FROM_ORG_ID;

Line: 570

      SELECT NVL(costing_group_id,-1)
      INTO   l_cost_group_id
      FROM   pjm_project_parameters ppp
      WHERE  ppp.project_id = l_line_rec.project_id
      AND    ppp.organization_id = G_SHIP_FROM_ORG_ID;

Line: 666

  SELECT NVL(default_cost_group_id,-1)
  INTO   l_cost_group_id
  FROM   mtl_parameters
  WHERE  organization_id = G_SHIP_FROM_ORG_ID;

Line: 684

   SELECT primary_uom_code
    INTO l_primary_uom_code
   FROM mtl_system_items
   WHERE inventory_item_id = p_inventory_item_id
    AND  organization_id = G_SHIP_FROM_ORG_ID;

Line: 726

   SELECT SET_OF_BOOKS_ID
   INTO   l_set_of_books_id
   FROM   ORG_ORGANIZATION_DEFINITIONS
   -- WHERE  ORGANIZATION_ID =  nvl(OE_ORDER_CACHE.g_header_rec.ship_from_org_id,G_SHIP_FROM_ORG_ID);

Line: 742

   SELECT Currency_Code
   INTO   G_SOB_CURRENCY
   FROM   OE_GL_SETS_OF_BOOKS_V
   WHERE  SET_OF_BOOKS_ID = l_set_of_books_id;

Line: 852

         l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 902

   SELECT a.min_margin_percent
   INTO   l_min_margin_percent
   FROM   OE_TRANSACTION_TYPES_ALL a,
          OE_ORDER_HEADERS_ALL     b
   WHERE  a.transaction_type_id = b.order_type_id
   AND    b.header_id = p_header_id;

Line: 942

SELECT ordered_quantity, unit_selling_price, unit_cost
  FROM  OE_ORDER_LINES_ALL
  WHERE header_id = p_header_id
  AND   unit_cost IS NOT NULL
  AND   line_category_code = 'ORDER';

Line: 985

 /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_selling_price),
         SUM(ordered_quantity*(unit_selling_price - unit_cost))
  INTO  l_margin_ratio,
        l_margin_amount
  FROM  OE_ORDER_LINES_ALL
  WHERE header_id = p_header_id
  AND   unit_cost IS NOT NULL
  -- AND   unit_selling_price > 0
  AND   line_category_code = 'ORDER';  */

Line: 1014

 /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_cost),
         SUM(ordered_quantity*(unit_selling_price- unit_cost))
  INTO  l_margin_ratio,
        l_margin_amount
  FROM  OE_ORDER_LINES_ALL
  WHERE header_id = p_header_id
  AND   unit_cost IS NOT NULL
  AND   line_category_code = 'ORDER';  */