APPS.INV_DIAG_RCV_RMA SQL Statements

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

Line: 114

  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 171

   select header_id
   into l_rma_count
   from oe_order_headers_all
   where org_id = l_operating_id
   and order_number = l_rma_number;

Line: 190

   select shipment_header_id
   into l_rma_count
   from rcv_shipment_headers
   where receipt_num = l_receipt_num
   and ship_to_org_id = l_org_id;

Line: 240

JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 242

JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'

'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
INDEX OF QUERIES
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
MTL_SYSTEM_ITEMS
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
PO_INTERFACE_ERRORS
ORG_ORG_DEFINITIONS
MTL_PARAMETERS
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_TYPES
MTL_TRANSACTION_REQUEST_LINES
MTL_MATERIAL_TRANSACTIONS_TEMP
OE_LOT_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_TEMP
MTL_SERIAL_NUMBERS_INTERFACE
MTL_UNIT_TRANSACTIONS
RCV_SERIAL_TRANSACTIONS
RCV_SERIAL_INTERFACE
MTL_PARAMETERS
MTL_LOT_NUMBERS
MTL_TRANSACTION_LOT_NUMBERS
MTL_TRANSACTION_LOT_INTERFACE
MTL_TRANSACTION_LOTS_TEMP
RCV_LOT_TRANSACTIONS
RCV_PARAMETERS
PO_SYSTEM_PARAMETERS_ALL
FINANCIAL_SYSTEM_PARAMETERS
LOOKUP CODES
');

Line: 306

JTF_DIAGNOSTIC_COREAPI.insert_html('
RMA Information
');

Line: 309

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 310

JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');

Line: 315

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 316

JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');

Line: 322

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 323

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

Line: 327

JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');

Line: 330

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 331

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

Line: 336

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 337

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

Line: 342

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 343

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

Line: 348

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 349

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

Line: 354

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 355

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 362

JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line: 366

JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');

Line: 369

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 370

JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');

Line: 375

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 376

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

Line: 381

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 382

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

Line: 387

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 388

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

Line: 393

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 394

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 401

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 408

JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');

Line: 413

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 414

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

Line: 419

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 420

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

Line: 425

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 426

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 433

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

Line: 438

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 439

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

Line: 444

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 445

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');

Line: 450

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 451

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

Line: 456

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 457

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 464

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 471

JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

Line: 476

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 477

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

Line: 482

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 483

JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

Line: 488

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 489

JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');

Line: 494

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 495

JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 501

JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');

Line: 503

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 504

JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

Line: 509

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 510

JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

Line: 515

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 516

JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line: 521

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 522

JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line: 527

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 528

JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line: 533

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 534

JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line: 539

JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 540

JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');