APPS.INV_DIAG_MO SQL Statements

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

Line: 19

 sqltxt    VARCHAR2(9999);  -- SQL select statement

Line: 34

JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 42

sqltxt :='SELECT DISTINCT period_name "Period|Name" '||
         ' , oap.acct_period_id "Period|Id"  '||
         ' , mp.organization_code "Organization|Code"  '||
         ' , mmtt.organization_id "Organization|Id" '||
         ' , TO_CHAR( period_start_date, ''DD-MON-YYYY'' ) "Start Date"  '||
         ' , TO_CHAR( period_close_date, ''DD-MON-YYYY'' ) "Close Date"  '||
         ' , TO_CHAR( schedule_close_date, ''DD-MON-YYYY'' ) "Scheduled |Close Date"  '||
         ' , open_flag "Open"  '||
         ' , description "Description"  '||
         ' , period_set_name "GL Period Set|Name"  '||
         ' , period_name "GL Period|Name"  '||
         ' , period_year "GL Period|Year"  '||
         ' FROM mtl_material_transactions_temp mmtt, mtl_parameters mp '||
         ' , org_acct_periods oap  '||
         'WHERE NVL( mmtt.transaction_status,1 ) != 2  '||
         'AND mmtt.organization_id=mp.organization_id(+)  '||
         'AND mmtt.acct_period_id=oap.acct_period_id(+)';

Line: 74

sqltxt :='SELECT organization_code || '' ('' ||mmtt.organization_id|| '')'' "Organization|Code (Id)" '||
         ',period_name "Period|Name", mmtt.acct_period_id "Period|Id" '||
         ',transaction_header_id "Txn|Header Id" '||
         ',transaction_temp_id "Txn|Temp Id"  '||
         ',TO_CHAR( transaction_date, ''DD-MON-RR'' ) "Txn|Date"  '||
         ',DECODE(transaction_mode,1,''Online'',2,''Concurrent'',3,''Background'',transaction_mode) ||'' ('' ||transaction_mode|| '')'' "Transaction|Mode" '||
         ',DECODE(transaction_status,1,''Pending'',2,''Allocated'',3,''Pending'',NULL,''Pending'',transaction_status) ||'' ('' ||transaction_status|| '')'' "Transaction|Status"  '||
         ',process_flag "Process|Flag"  '||
         ',lock_flag "Lock|Flag"  '||
         ',error_code  '||
         ',error_explanation  '||
         ',TO_CHAR( mmtt.last_update_date, ''DD-MON-RR HH24:MI'') "Last Updated" '||
         ',mif.item_number ||'' (''||mmtt.inventory_item_id||'')'' "Item (Id)"  '||
         ',item_description "Item Description"  '||
         ' ,revision "Rev" ,lot_number "Lot" ,serial_number "Serial|Number" '||
         ',mmtt.cost_group_id "Cost|Group Id" ,mmtt.subinventory_code "Subinv" '||
         ',mil.description  ||'' (''||mmtt.locator_id||'') '' "Stock|Locator (Id)"  '||
         ',transfer_subinventory "Transfer|Subinv" ,transfer_to_location "Transfer|Location"  '||
         ',transaction_quantity "Txn Qty" ,primary_quantity "Primary|Qty" ,transaction_uom "Txn|UoM"  '||
         ',mtt.transaction_type_name ||'' (''||mmtt.transaction_type_id||'')'' "Txn Type (Id)",ml.meaning||'' (''||mmtt.transaction_action_id||'')'' "Txn Action Type (Id)" '||
         'FROM mtl_material_transactions_temp mmtt ,mtl_transaction_types mtt  '||
         ',mtl_item_flexfields mif ,mfg_lookups ml ,mtl_item_locations_kfv mil ,mtl_parameters mp,org_acct_periods oap '||
         ' WHERE NVL(transaction_status,1)!=2 '||
         'AND mmtt.transaction_type_id=mtt.transaction_type_id '||
         'AND mmtt.organization_id=mif.organization_id(+) '||
         'AND mmtt.inventory_item_id=mif.inventory_item_id(+)'||
         'AND mmtt.transaction_action_id=ml.lookup_code '||
         'AND ml.lookup_type=''MTL_TRANSACTION_ACTION'' '||
         'AND mmtt.locator_id=mil.inventory_location_id(+) '||
         'AND mmtt.organization_id=mil.organization_id(+)'||
         'AND mmtt.organization_id=mp.organization_id(+) '||
         'AND mmtt.acct_period_id=oap.acct_period_id(+) '||
         'AND mmtt.acct_period_id=oap.acct_period_id(+) ';