APPS.GMI_ICR03_XMLP_PKG SQL Statements

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

Line: 10

      SELECT
        H.BATCH_NO
      INTO D_NO
      FROM
        PM_MATL_DTL D,
        PM_BTCH_HDR H,
        FM_FORM_MST F
      WHERE D.BATCH_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BATCH_ID = H.BATCH_ID
        AND H.FORMULA_ID = F.FORMULA_ID
        AND H.DELETE_MARK = 0
        AND F.DELETE_MARK = 0;

Line: 28

      SELECT
        H.PO_NO
      INTO D_NO
      FROM
        PO_ORDR_HDR H,
        PO_ORDR_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.PO_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.PO_ID = H.PO_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0;

Line: 48

      SELECT
        H.ORDER_NO
      INTO D_NO
      FROM
        OP_ORDR_HDR H,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.ORDER_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.ORDER_ID = H.ORDER_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 69

      SELECT
        H.RECV_NO
      INTO D_NO
      FROM
        PO_RECV_HDR H,
        PO_RECV_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.RECV_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.RECV_ID = H.RECV_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 90

      SELECT
        B1.BOL_NO
      INTO D_NO
      FROM
        OP_BILL_LAD B1,
        OP_BILL_LAD B2,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE B1.BOL_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BOL_ID = B2.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND B2.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 113

      SELECT
        B1.BOL_NO
      INTO D_NO
      FROM
        OP_BILL_LAD B1,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.INVOICE_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.INVOICE_ID = B1.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = B1.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 134

      SELECT
        M.JOURNAL_NO
      INTO D_NO
      FROM
        IC_JRNL_MST M,
        IC_ADJS_JNL D
      WHERE D.DOC_ID = DOC_ID
        AND D.ITEM_ID = ITEM_ID1
        AND D.LINE_ID = LINE_ID1
        AND D.JOURNAL_ID = M.JOURNAL_ID;

Line: 148

      SELECT
        TRANSFER_NO
      INTO D_NO
      FROM
        IC_XFER_MST
      WHERE TRANSFER_ID = DOC_ID
        AND ITEM_ID = ITEM_ID1;

Line: 159

      SELECT
        DISTINCT
        RSH.RECEIPT_NUM
      INTO D_NO
      FROM
        RCV_SHIPMENT_LINES RSL,
        RCV_SHIPMENT_HEADERS RSH,
        RCV_TRANSACTIONS RT
      WHERE RT.TRANSACTION_ID = LINE_ID1
        AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
        AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID;

Line: 174

      SELECT
        DISTINCT
        OOH.ORDER_NUMBER
      INTO D_NO
      FROM
        OE_ORDER_HEADERS_ALL OOH,
        OE_ORDER_LINES_ALL OOL
      WHERE OOL.LINE_ID = LINE_ID1
        AND OOH.HEADER_ID = OOL.HEADER_ID;

Line: 200

      SELECT
        F.FORMULA_NO
      INTO F_NO
      FROM
        PM_MATL_DTL D,
        PM_BTCH_HDR H,
        FM_FORM_MST F
      WHERE D.BATCH_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BATCH_ID = H.BATCH_ID
        AND H.FORMULA_ID = F.FORMULA_ID
        AND H.DELETE_MARK = 0
        AND F.DELETE_MARK = 0;

Line: 231

      SELECT
        F.FORMULA_VERS
      INTO V_NO
      FROM
        PM_MATL_DTL D,
        PM_BTCH_HDR H,
        FM_FORM_MST F
      WHERE D.BATCH_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BATCH_ID = H.BATCH_ID
        AND H.FORMULA_ID = F.FORMULA_ID
        AND H.DELETE_MARK = 0
        AND F.DELETE_MARK = 0;

Line: 262

      SELECT
        V.VENDOR_NO
      INTO V_S_L
      FROM
        PO_ORDR_HDR H,
        PO_ORDR_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.PO_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.PO_ID = H.PO_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0;

Line: 282

      SELECT
        V.CUST_NO
      INTO V_S_L
      FROM
        OP_ORDR_HDR H,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.ORDER_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.ORDER_ID = H.ORDER_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 303

      SELECT
        V.VENDOR_NO
      INTO V_S_L
      FROM
        PO_RECV_HDR H,
        PO_RECV_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.RECV_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.RECV_ID = H.RECV_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 324

      SELECT
        V.CUST_NO
      INTO V_S_L
      FROM
        OP_BILL_LAD B1,
        OP_BILL_LAD B2,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE B1.BOL_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BOL_ID = B2.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 347

      SELECT
        V.CUST_NO
      INTO V_S_L
      FROM
        OP_BILL_LAD B1,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.INVOICE_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.INVOICE_ID = B1.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = B1.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 381

      SELECT
        D.FRTBILL_MTHD
      INTO F_M
      FROM
        PO_ORDR_HDR H,
        PO_ORDR_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.PO_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.PO_ID = H.PO_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0;

Line: 401

      SELECT
        D.FRTBILL_MTHD
      INTO F_M
      FROM
        OP_ORDR_HDR H,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.ORDER_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.ORDER_ID = H.ORDER_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 422

      SELECT
        D.FRTBILL_MTHD
      INTO F_M
      FROM
        PO_RECV_HDR H,
        PO_RECV_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.RECV_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.RECV_ID = H.RECV_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 443

      SELECT
        D.FRTBILL_MTHD
      INTO F_M
      FROM
        OP_BILL_LAD B1,
        OP_BILL_LAD B2,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE B1.BOL_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BOL_ID = B2.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 466

      SELECT
        D.FRTBILL_MTHD
      INTO F_M
      FROM
        OP_BILL_LAD B1,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.INVOICE_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.INVOICE_ID = B1.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = B1.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 500

      SELECT
        D.SHIP_MTHD
      INTO S_M
      FROM
        PO_ORDR_HDR H,
        PO_ORDR_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.PO_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.PO_ID = H.PO_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0;

Line: 520

      SELECT
        D.SHIP_MTHD
      INTO S_M
      FROM
        OP_ORDR_HDR H,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.ORDER_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.ORDER_ID = H.ORDER_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 541

      SELECT
        D.SHIP_MTHD
      INTO S_M
      FROM
        PO_RECV_HDR H,
        PO_RECV_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.RECV_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.RECV_ID = H.RECV_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 562

      SELECT
        D.SHIP_MTHD
      INTO S_M
      FROM
        OP_BILL_LAD B1,
        OP_BILL_LAD B2,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE B1.BOL_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BOL_ID = B2.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 585

      SELECT
        D.SHIP_MTHD
      INTO S_M
      FROM
        OP_BILL_LAD B1,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.INVOICE_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.INVOICE_ID = B1.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = B1.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 619

      SELECT
        S.SHIPPER_NAME
      INTO S_N
      FROM
        PO_ORDR_HDR H,
        PO_ORDR_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.PO_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.PO_ID = H.PO_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0;

Line: 639

      SELECT
        S.SHIPPER_NAME
      INTO S_N
      FROM
        OP_ORDR_HDR H,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.ORDER_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.ORDER_ID = H.ORDER_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 660

      SELECT
        S.SHIPPER_NAME
      INTO S_N
      FROM
        PO_RECV_HDR H,
        PO_RECV_DTL D,
        PO_VEND_MST V,
        OP_SHIP_MST S
      WHERE D.RECV_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.RECV_ID = H.RECV_ID
        AND V.VENDOR_ID = D.SHIPVEND_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND H.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 681

      SELECT
        S.SHIPPER_NAME
      INTO S_N
      FROM
        OP_BILL_LAD B1,
        OP_BILL_LAD B2,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE B1.BOL_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.BOL_ID = B2.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = D.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 704

      SELECT
        S.SHIPPER_NAME
      INTO S_N
      FROM
        OP_BILL_LAD B1,
        OP_ORDR_DTL D,
        OP_CUST_MST V,
        OP_SHIP_MST S
      WHERE D.INVOICE_ID = DOC_ID
        AND D.LINE_ID = LINE_ID1
        AND D.ITEM_ID = ITEM_ID1
        AND D.INVOICE_ID = B1.BOL_ID
        AND V.CUST_ID = D.SHIPCUST_ID
        AND S.SHIPPER_CODE = B1.SHIPPER_CODE
        AND B1.DELETE_MARK = 0
        AND S.DELETE_MARK = 0
        AND V.DELETE_MARK = 0;

Line: 734

    SELECT
      DOC_TYPE
    INTO DOC_TYPE1
    FROM
      DUAL;

Line: 749

    SELECT
      DECODE(FROM_WHSE
            ,NULL
            ,DECODE(TO_WHSE
                  ,NULL
                  ,'Warehouse Range : All '
                  ,' Warehouse: All  - ' || TO_WHSE)
            ,DECODE(TO_WHSE
                  ,NULL
                  ,'Warehouse Range: ' || FROM_WHSE || ' - All '
                  ,' Warehouse Range: ' || FROM_WHSE || ' - ' || TO_WHSE))
    INTO RANGEV
    FROM
      DUAL;

Line: 810

    SELECT
      UNIT_COSTCF * COUNT_QTYSC
    INTO COSTACCUM
    FROM
      DUAL;