APPS.PO_POXDLPDT_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      STRUCTURE_ID
    INTO L_P_STRUCT_NUM
    FROM
      MTL_DEFAULT_SETS_VIEW
    WHERE FUNCTIONAL_AREA_ID = 2;

Line: 36

        SELECT
          TRANSACTION_TYPE
        INTO L_TRANSACTION_TYPE
        FROM
          RCV_TRANSACTIONS
        WHERE TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 57

        SELECT
          AUTO_TRANSACT_CODE,
          TRANSACTION_TYPE
        INTO L_AUTO_TRANSACT_CODE,L_TRANSACTION_TYPE
        FROM
          RCV_TRANSACTIONS_INTERFACE
        WHERE INTERFACE_TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 87

    SELECT
      BLIND_RECEIVING_FLAG
    INTO L_BLIND_RECEIVING_FLAG
    FROM
      RCV_PARAMETERS
    WHERE ORGANIZATION_ID = RRP_ORGANIZATION_ID;

Line: 112

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'TYPE';

Line: 123

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'DOCUMENT TYPE';

Line: 143

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'SHIPMENT NUMBER';

Line: 154

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'DOCUMENT NUMBER';

Line: 174

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'BUYER';

Line: 185

        SELECT
          DISPLAYED_FIELD
        INTO L_DISPLAYED_FIELD
        FROM
          PO_LOOKUP_CODES
        WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
          AND LOOKUP_CODE = 'PREPARER';

Line: 218

        SELECT
          TRANSACTION_TYPE
        INTO L_TRANSACTION_TYPE
        FROM
          RCV_TRANSACTIONS
        WHERE TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 234

        SELECT
          AUTO_TRANSACT_CODE
        INTO L_AUTO_TRANSACT_CODE
        FROM
          RCV_TRANSACTIONS_INTERFACE
        WHERE INTERFACE_TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 269

        SELECT
          USER_ENTERED_FLAG,
          TRANSACTION_TYPE
        INTO L_USER_ENTERED_FLAG,L_TRANSACTION_TYPE
        FROM
          RCV_TRANSACTIONS
        WHERE PARENT_TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 311

      RETURN ('SELECT WE.WIP_ENTITY_NAME                 Work_Order
             ,       to_char(null)                                    Line
             ,      WRO.DATE_REQUIRED                  Date_Required
             ,      SUM(NVL(WRO.QUANTITY_ISSUED,0))                Quantity_Issued
             ,      SUM(NVL(WRO.REQUIRED_QUANTITY,0))           Quantity_Required
             ,       NVL(MOQ2.TRANSACTION_QUANTITY,0)        Quantity_On_Hand
             ,      ''D''                                                                                                    Processing_Mode');

Line: 325

      RETURN ('SELECT WE.WIP_ENTITY_NAME                 Work_Order
             ,      WL.LINE_CODE                         Line
             ,      WRO.DATE_REQUIRED                  Date_Required
             ,      SUM(WRO.QUANTITY_ISSUED)                Quantity_Issued
             ,      SUM((LEAST(BCD.NEXT_SEQ_NUM + WRS.PROCESSING_WORK_DAYS,BCD1.NEXT_SEQ_NUM + MSI.POSTPROCESSING_LEAD_TIME)
                       - GREATEST(BCD.NEXT_SEQ_NUM,BCD1.NEXT_SEQ_NUM))
                       * WRO.QUANTITY_PER_ASSEMBLY * WRS.DAILY_PRODUCTION_RATE )
             /* this is raw quantity required */
                     +    -1 *  SUM(WRO.QUANTITY_ISSUED -
                        GREATEST((BCD1.NEXT_SEQ_NUM-BCD.NEXT_SEQ_NUM),0)
                    *WRO.QUANTITY_PER_ASSEMBLY * WRS.DAILY_PRODUCTION_RATE)
             /* this is the quantity ahead behind after taking care of the negative sign as quantity ahead behind
             will always be calulated as negative*/
                                                         Quantity_Required
             ,      NVL(MOQ2.TRANSACTION_QUANTITY,0)         Quantity_On_Hand
             ,      ''R''                                      Processing_Mode');

Line: 444

  FUNCTION WIP_SELECT_DISTFORMULA RETURN VARCHAR2 IS
  BEGIN
    IF (P_WIP_STATUS = 'I') THEN
      RETURN (',         we.wip_entity_name          job_or_schedule
             ,        wl.line_code               line
             ,        wn.operation_seq_num   op_seq
             ,        bd.department_code      department');

Line: 453

  END WIP_SELECT_DISTFORMULA;

Line: 549

      SELECT
        TRANSACTION_TYPE
      INTO L_TRANSACTION_TYPE
      FROM
        RCV_TRANSACTIONS
      WHERE TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 556

      SELECT
        TRANSACTION_TYPE
      INTO L_TRANSACTION_TYPE
      FROM
        RCV_TRANSACTIONS_INTERFACE
      WHERE INTERFACE_TRANSACTION_ID = RRP_TRANSACTION_ID;

Line: 570

      SELECT
        QUANTITY_RECEIVED,
        UNIT_OF_MEASURE
      INTO QTY,L_UOM
      FROM
        RCV_SHIPMENT_LINES
      WHERE SHIPMENT_LINE_ID = RRP_SHIPMENT_LINE_ID;

Line: 694

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = ITEM_NOTE_MEDIA_ID;

Line: 702

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = ITEM_NOTE_MEDIA_ID;

Line: 720

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = LONG_NOTE_MEDIA_ID;

Line: 728

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = LONG_NOTE_MEDIA_ID;

Line: 746

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = TRX_NOTE_MEDIA_ID;

Line: 754

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = TRX_NOTE_MEDIA_ID;

Line: 772

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = PO_HEADER_NOTE_MEDIA_ID;

Line: 780

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = PO_HEADER_NOTE_MEDIA_ID;

Line: 798

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = PO_LINE_NOTE_MEDIA_ID;

Line: 806

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = PO_LINE_NOTE_MEDIA_ID;

Line: 824

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = REQ_HEADER_NOTE_MEDIA_ID;

Line: 832

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = REQ_HEADER_NOTE_MEDIA_ID;

Line: 850

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = REQ_LINE_NOTE_MEDIA_ID;

Line: 858

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = REQ_LINE_NOTE_MEDIA_ID;

Line: 876

      SELECT
        SHORT_TEXT
      INTO SHORT_NOTE
      FROM
        FND_DOCUMENTS_SHORT_TEXT
      WHERE MEDIA_ID = SHIPMENT_NOTE_MEDIA_ID;

Line: 884

      SELECT
        LONG_TEXT
      INTO LONG_NOTE
      FROM
        FND_DOCUMENTS_LONG_TEXT
      WHERE MEDIA_ID = SHIPMENT_NOTE_MEDIA_ID;

Line: 934

            SELECT
              ORGANIZATION_NAME
            INTO L_ORG_DISPLAYED
            FROM
              ORG_ORGANIZATION_DEFINITIONS
            WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 952

        SELECT
          DISTINCT
          MANUAL_RECEIPT_NUM_TYPE
        INTO NUMBERING_TYPE
        FROM
          RCV_RECEIVING_PARAMETERS_V
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 1003

          P_WIP_SELECT_DIST := ' we.wip_entity_name job_or_schedule
                                                           , wl.line_code line
                                                           , wn.operation_seq_num op_seq
                                                           , bd.department_code department ';

Line: 1031

          P_UNION_UPPER_UPPER := 'SELECT WE.WIP_ENTITY_NAME                 Work_Order
                                 ,       to_char(null)                                    Line
                                 ,      WRO.DATE_REQUIRED                  Date_Required
                                 ,      SUM(NVL(WRO.QUANTITY_ISSUED,0))                Quantity_Issued
                                 ,      SUM(NVL(WRO.REQUIRED_QUANTITY,0))           Quantity_Required
                                 ,      ''D''                ';

Line: 1061

          P_UNION_LOWER_UPPER := 'SELECT WE.WIP_ENTITY_NAME                 Work_Order
                                 ,      WL.LINE_CODE                         Line
                                 ,      WRO.DATE_REQUIRED                  Date_Required
                                 ,      SUM(WRO.QUANTITY_ISSUED)                Quantity_Issued
                                 ,      SUM((LEAST(BCD.NEXT_SEQ_NUM + WRS.PROCESSING_WORK_DAYS,BCD1.NEXT_SEQ_NUM + MSI.POSTPROCESSING_LEAD_TIME)
                                           - GREATEST(BCD.NEXT_SEQ_NUM,BCD1.NEXT_SEQ_NUM))
                                           * WRO.QUANTITY_PER_ASSEMBLY * WRS.DAILY_PRODUCTION_RATE )
                                 /* this is raw quantity required */
                                         +    -1 *  SUM(WRO.QUANTITY_ISSUED -
                                            GREATEST((BCD1.NEXT_SEQ_NUM-BCD.NEXT_SEQ_NUM),0)
                                        *WRO.QUANTITY_PER_ASSEMBLY * WRS.DAILY_PRODUCTION_RATE)
                                 /* this is the quantity ahead behind after taking care of the negative sign as quantity ahead behind
                                 will always be calulated as negative*/
                                                                             Quantity_Required
                                 ,      ''R''                                      Processing_Mode';

Line: 1179

    SELECT
      SUM(NVL(QUANTITY
             ,0))
    INTO QUANTITY_ON_HAND
    FROM
      MTL_ITEM_QUANTITIES_VIEW
    WHERE INVENTORY_ITEM_ID = JOIN_ITEM_ID
      AND ORGANIZATION_ID = JOIN_ORGANIZATION_ID;

Line: 1307

      SELECT
        CONCATENATED_SEGMENTS
      INTO L_LOCATOR
      FROM
        MTL_ITEM_LOCATIONS_KFV
      WHERE INVENTORY_LOCATION_ID = LOCATOR_ID1;