The following lines contain the word 'select', 'insert', 'update' or 'delete':
sqltxt VARCHAR2(9999); -- SQL select statement
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
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(+)';
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(+) ';