This content has been marked as final. Show 2 replies
"what is name of sequence relating to requisition number?"
can you explain a little bit more in detail the question? Lately I have been working with that table and maybe i can help you.
Very good question.
Here is your answer: Normally Sequences are created similar to Table names with a "_s" in the end. That is the coding standard also.
To find out the sequences on PO_REQUISITION_HEADERS_ALL table for instance use this query:
SELECT * FROM FND_SEQUENCES WHERE SEQUENCE_NAME LIKE 'PO%REQ%'
and check out the description column for more understanding!
P.S: Sequence Name is PO_REQUISITION_HEADERS_S