[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Manufacturing resource planning interface lines view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INTFLINES.ROWID
, INTFLINES.LINE_SEQUENCE_ID
, INTFLINES.SEQUENCE_ID
, INTFLINES.LAST_UPDATE_DATE
, INTFLINES.LAST_UPDATED_BY
, INTFLINES.CREATION_DATE
, INTFLINES.CREATED_BY
, INTFLINES.LAST_UPDATE_LOGIN
, INTF.ORGANIZATION_ID
, INTF.FORECAST_DESIGNATOR
, INTFLINES.INTEREST_TYPE_ID
, INTTYPE.INTEREST_TYPE
, INTFLINES.PRIMARY_INTEREST_CODE_ID
, INTCODE1.CODE
, INTFLINES.SECONDARY_INTEREST_CODE_ID
, INTCODE2.CODE
, INTFLINES.PF_ITEM_ID
, INTFLINES.ITEM_ID
, INTFLINES.FORECAST_DATE
, INTFLINES.FORECAST_UPSIDE_FLAG
, INTFLINES.QUANTITY
, INTFLINES.CONFIDENCE_PERCENTAGE
, INTFLINES.PROCESS_STATUS
, INTFLINES.ERROR_MESSAGE
, INTFLINES.COMMENTS
FROM AS_MRP_INTERFACE_LINES INTFLINES
, AS_MRP_INTERFACE INTF
, AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_VL INTCODE1
, AS_INTEREST_CODES_VL INTCODE2
WHERE INTFLINES.SEQUENCE_ID = INTF.SEQUENCE_ID
AND INTFLINES.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)
AND INTFLINES.PRIMARY_INTEREST_CODE_ID = INTCODE1.INTEREST_CODE_ID(+)
AND INTFLINES.SECONDARY_INTEREST_CODE_ID = INTCODE2.INTEREST_CODE_ID(+)