APPS.GMF_GMFLCHST_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        BASE_CURRENCY_CODE
      FROM
        GMF_FISCAL_POLICIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 125

      SELECT
        PLANT_CODE || ' ' || BATCH_NO
      FROM
        GME_BATCH_HEADER
      WHERE BATCH_ID = DOC_ID;

Line: 131

      SELECT
        DISTINCT
        MP.ORGANIZATION_CODE || ' ' || R.RECEIPT_NUM
      FROM
        RCV_SHIPMENT_HEADERS R,
        MTL_MATERIAL_TRANSACTIONS P,
        MTL_PARAMETERS MP
      WHERE R.SHIPMENT_HEADER_ID = P.TRANSACTION_SOURCE_ID
        AND R.ORGANIZATION_ID = P.ORGANIZATION_ID
        AND P.TRANSACTION_SOURCE_ID = DOC_ID
        AND P.TRX_SOURCE_LINE_ID = LINE_ID
        AND MP.ORGANIZATION_ID = P.ORGANIZATION_ID;

Line: 144

      SELECT
        DISTINCT
        J.ORGN_CODE || ' ' || J.JOURNAL_NO
      FROM
        IC_JRNL_MST J,
        IC_ADJS_JNL D
      WHERE D.TRANS_TYPE = DOC_TYPE
        AND D.DOC_ID = DOC_ID
        AND J.JOURNAL_ID = D.JOURNAL_ID;

Line: 154

      SELECT
        MP.ORGANIZATION_CODE || ' ' || MCC.COUNT_LIST_SEQUENCE
      FROM
        MTL_MATERIAL_TRANSACTIONS MTT,
        MTL_PARAMETERS MP,
        MTL_CYCLE_COUNT_ENTRIES MCC
      WHERE MTT.CYCLE_COUNT_ID = DOC_ID
        AND MP.ORGANIZATION_ID = MTT.ORGANIZATION_ID
        AND MCC.CYCLE_COUNT_ENTRY_ID = MTT.CYCLE_COUNT_ID;

Line: 164

      SELECT
        MP.ORGANIZATION_CODE
      FROM
        MTL_MATERIAL_TRANSACTIONS MMT,
        MTL_PARAMETERS MP
      WHERE MMT.TRANSFER_TRANSACTION_ID = DOC_ID
        AND MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID;

Line: 172

      SELECT
        DISTINCT
        MP.ORGANIZATION_CODE || ' ' || D.NAME
      FROM
        WSH_NEW_DELIVERIES D,
        MTL_MATERIAL_TRANSACTIONS T,
        WSH_DELIVERY_DETAILS WD,
        WSH_DELIVERY_ASSIGNMENTS WA,
        MTL_PARAMETERS MP,
        MTL_TXN_SOURCE_TYPES MTST,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE D.DELIVERY_ID = WA.DELIVERY_ID
        AND WA.DELIVERY_DETAIL_ID = WD.DELIVERY_DETAIL_ID
        AND OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
        AND T.TRANSACTION_SOURCE_ID = P_DOC_ID
        AND T.TRX_SOURCE_LINE_ID = P_LINE_ID
        AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
        AND MTST.TRANSACTION_SOURCE_TYPE_ID = T.TRANSACTION_SOURCE_TYPE_ID
        AND T.ORGANIZATION_ID = MP.ORGANIZATION_ID
        AND OOD.ORGANIZATION_ID = T.ORGANIZATION_ID;

Line: 193

      SELECT
        DISTINCT
        '(Bill-Only) ' || MP.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
      FROM
        MTL_PARAMETERS MP,
        MTL_MATERIAL_TRANSACTIONS T,
        OE_ORDER_HEADERS_ALL OH,
        OE_ORDER_LINES_ALL OL,
        MTL_TXN_SOURCE_TYPES MTST,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
        AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
        AND T.TRANSACTION_SOURCE_ID = P_DOC_ID
        AND T.TRX_SOURCE_LINE_ID = P_LINE_ID
        AND T.TRX_SOURCE_LINE_ID = OL.LINE_ID
        AND OH.HEADER_ID = OL.HEADER_ID
        AND OOD.ORGANIZATION_ID = T.ORGANIZATION_ID
        AND MTST.TRANSACTION_SOURCE_TYPE_ID = T.TRANSACTION_SOURCE_TYPE_ID;

Line: 212

      SELECT
        DISTINCT
        '(Drop-Ship) ' || OOD.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
      FROM
        MTL_MATERIAL_TRANSACTIONS T,
        OE_ORDER_HEADERS_ALL OH,
        OE_ORDER_LINES_ALL OL,
        MTL_TXN_SOURCE_TYPES MTST,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
        AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
        AND T.TRANSACTION_SOURCE_ID = P_DOC_ID
        AND T.TRX_SOURCE_LINE_ID = P_LINE_ID
        AND T.TRX_SOURCE_LINE_ID = OL.LINE_ID
        AND OH.HEADER_ID = OL.HEADER_ID
        AND OOD.ORGANIZATION_ID = T.ORGANIZATION_ID
        AND MTST.TRANSACTION_SOURCE_TYPE_ID = T.TRANSACTION_SOURCE_TYPE_ID
        AND EXISTS (
        SELECT
          1
        FROM
          OE_DROP_SHIP_SOURCES S
        WHERE OL.LINE_ID = S.LINE_ID
          AND OL.HEADER_ID = S.HEADER_ID );

Line: 237

      SELECT
        DISTINCT
        B.ORGN_CODE || ' ' || B.BOL_NO
      FROM
        OP_ORDR_DTL D,
        OP_BILL_LAD B
      WHERE D.LINE_ID = P_LINE_ID
        AND D.BOL_ID = B.BOL_ID;

Line: 249

       SELECT rsh.receipt_num, glat.lc_ship_num
       FROM  gmf_lc_adj_transactions glat,
             rcv_transactions rt,
             rcv_shipment_headers rsh
       WHERE glat.rcv_transaction_id = rt.transaction_id
       AND   rsh.shipment_header_id  = rt.shipment_header_id
       AND   glat.adj_transaction_id = l_adj_transaction_id  ;

Line: 344

      SELECT
        LEGAL_ENTITY_NAME
      INTO L_LEGAL_ENTITY_NAME
      FROM
        GMF_LEGAL_ENTITIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 360

      SELECT
        COST_MTHD_CODE
      INTO L_COST_MTHD_CODE
      FROM
        CM_MTHD_MST
      WHERE COST_TYPE_ID = P_COST_TYPE_ID;