Monday, March 12, 2018
Query to fetch Operating Unit wise Document Number Sequences Setup at Purchasing System Options in R12
Today, i was trying to get the next sequence number used for different transaction types like PO_HEADERS, PO LINES, RFQ, REQUISITION Number setup at PO System Options.
The query i arrived is given below. May its useful for others as well.
Instance: R12
Query:
SELECT hou.short_code, puidc.current_max_unique_identifier Next_seq_number, puidc.table_name, puidc.org_id FROM po_unique_identifier_cont_all puidc, hr_operating_units hou WHERE table_name IN ('PO_HEADERS_RFQ',
'PO_HEADERS_QUOTE',
'PO_HEADERS',
'PO_REQUISITION_HEADERS'
) AND hou.organization_id = puidc.org_id;
Hope it helps!!
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Query to fetch Operating Unit wise Document Number Sequences Setup at Purchasing System Options in R12”
Post a Comment