APPS.INV_DIAG_RSV_HDR_ZERO SQL Statements

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

Line: 46

    JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 49

    sqltxt := ' SELECT MR.RESERVATION_ID RSV_ID,' ||
              ' MR.DEMAND_SOURCE_LINE_ID ORDER_LINE_ID,' ||
              ' MR.INVENTORY_ITEM_ID ITEM_ID,' ||
              ' MR.ORGANIZATION_ID ORG_ID,' ||
              ' MR.PRIMARY_RESERVATION_QUANTITY PRSV_QTY' ||
              ' FROM  MTL_RESERVATIONS MR' ||
              ' WHERE DEMAND_SOURCE_TYPE_ID IN (2,8)' ||
              ' AND NVL(DEMAND_SOURCE_HEADER_ID, 0) = 0' ||
              ' AND SUPPLY_SOURCE_TYPE_ID = 13 ';

Line: 61

    sqltxt := ' SELECT MD.DEMAND_ID DEMD_ID,' ||
              ' MD.DEMAND_SOURCE_LINE ORDER_LINE_ID,' ||
              ' MD.INVENTORY_ITEM_ID ITEM_ID,' ||
              ' MD.ORGANIZATION_ID ORG_ID,' ||
              ' MD.PRIMARY_UOM_QUANTITY PDEMD_QTY' ||
              ' FROM  MTL_DEMAND MD' ||
              ' WHERE DEMAND_SOURCE_TYPE IN (2,8)' ||
              ' AND NVL(DEMAND_SOURCE_HEADER_ID, 0) = 0' ||
              ' AND NVL(SUPPLY_SOURCE_TYPE, 13) = 13 ';