Tuesday, September 18, 2012

Link between Internal requisition and Internal sales order


1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID =



po_requisition_lines_all.REQUISITION_LINE_ID

2. OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition Number)

3. OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition number)

Tuesday, September 11, 2012

Displaying ROWID in TOAD

That’s EXACTLY what it is.



In your data grid, mouse-right-click – SELECT COLUMNS



Enable ‘ROWID’



You also have –



Toad – View – Options – Data Grids – Data – Display – ‘Show ROWID in editable grids’