You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Request for EBS R12 collection SQL to populate ScpPurchaseOrderRcvHistoryImportTemplate.xlsm

in Supply Chain Planning and Collaboration 1 comment

Summary:

Request for EBS R12 collection SQL to populate ScpPurchaseOrderRcvHistoryImportTemplate.xlsm

Content (please ensure you mask any confidential information):

Collect PO receiving history from EBS R12 with "ScpPurchaseOrderRcvHistoryImportTemplate"

with Buyer Managed Transportation=N

And we expect:

Variance Days= Receipt Date-Promised delivery date/Requested delivery date
Historical LT=Variance Days +Supplier Lead Time

Can you please advise if Oracle have an official SQL collection script for EBS R12 to populate the column need on ScpPurchaseOrderRcvHistoryImportTemplate?

We need assistance with

Inventory Item Name
Organization Code
Supplier Name
Supplier Site Code
Order Date
Receipt Date
Shipment Line Number
Receipt Number
Schedule Line Number

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!