Procurement - EBS (MOSC)

MOSC Banner

SQL Script to find Contract Numner from Oracle Purchasing (11.5.10.2)

edited Jun 16, 2015 11:33PM in Procurement - EBS (MOSC) 2 commentsAnswered ✓

I have the following script and can get contract_id but cannot get contract number. The contract number is blank but I cant get the contract_id. How can I change my script to get the contract_num.? Is there a join or another table.? Any help would be appreciated.

Thanks

SELECT ph.segment1 "PO_NUM",

  authorization_status,

  pov.segment1 as supplier_num,

  pov.vendor_name as vendor,

  pl.line_num "LINE_NUM",

  pl.po_line_id, 

  pl.po_header_id,

  pl.line_type_id, 

  pltb.order_type_lookup_code, 

  pl.item_id, 

  pl.item_description, 

  pl.unit_price,

  pl

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center