[Home] [Help]
View: MRP_RHX_ITEM_SUPPLIERS_V
| Product: | MRP - Master Scheduling/MRP |
|---|
| Description: | An Integration Toolkit view supporting information regarding vendors |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_NUMBER
, ITEMS.ORGANIZATION_ID
, ASL.ASL_ID
, TRUNC(SYSDATE) - MRP_RHX_EXT_APS.GET_CONSTANT
, TO_DATE('25/12/2500'
, 'DD/MM/RRRR')
, ASL.VENDOR_ID
, POVENDORS.VENDOR_NAME
, 1
FROM PO_VENDORS POVENDORS
, PO_APPROVED_SUPPLIER_LIST ASL
, MRP_RHX_PLANNED_ITEMS_V ITEMS
WHERE POVENDORS.VENDOR_ID = ASL.VENDOR_ID
AND ASL.ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND DECODE(ASL.USING_ORGANIZATION_ID
, -1
, ITEMS.ORGANIZATION_ID
, ASL.USING_ORGANIZATION_ID) = ITEMS.ORGANIZATION_ID
AND ITEMS.PLANNING_MAKE_BUY_CODE = 2
Columns
| Name |
| INVENTORY_ITEM_ID |
| ITEM_NUMBER |
| ORGANIZATION_ID |
| AUTOSOURCE_RULE_ID |
| START_DATE |
| END_DATE |
| VENDOR_ID |
| VENDOR_NAME |
| VENDOR_RANK |