FOS_PURCHASE_ORDER_ENTITIES_V

Details

• Schema: FUSION

• Object owner: FOS

• Object type: VIEW

Columns

Name
AGREEMENT_PTR_ID SOLD_TO_LE_ID SOLD_TO_LE PURCHASING_TRADE_ORG_ID

Query

SQL_Statement

SELECT DISTINCT PTR.AGREEMENT_PTR_ID, PTR.FROM_LE_ID SOLD_TO_LE_ID, LE.NAME SOLD_TO_LE, FTR.FROM_TRADE_ORG PURCHASING_TRADE_ORG_ID FROM FOS_AGREEMENT_PTR_F PTR JOIN XLE_ENTITY_PROFILES LE ON PTR.FROM_LE_ID = LE.LEGAL_ENTITY_ID JOIN FOS_AGREEMENT_FTR_F FTR ON PTR.AGREEMENT_PTR_ID = FTR.AGREEMENT_PTR_ID AND FTR.SEQUENCE_NUMBER = (SELECT MIN(FTR2.SEQUENCE_NUMBER) FROM FOS_AGREEMENT_FTR_F FTR2 WHERE FTR2.AGREEMENT_PTR_ID = PTR.AGREEMENT_PTR_ID GROUP BY FTR2.AGREEMENT_PTR_ID) ORDER by PTR.AGREEMENT_PTR_ID