[Home] [Help]
View: MRP_AP_PO_SUPPLIERS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT MASIS.INVENTORY_ITEM_ID
, MASIS.ORGANIZATION_ID
, PASLVV.USING_ORGANIZATION_ID
, PASLVV.ASL_ID
, PAA.PROCESSING_LEAD_TIME
, PAA.MIN_ORDER_QTY MINIMUM_ORDER_QUANTITY
, PAA.FIXED_LOT_MULTIPLE
, PAA.DELIVERY_CALENDAR DELIVERY_CALENDAR_CODE
, PAA.VENDOR_ID
, PAA.VENDOR_SITE_ID
, PASLVV.RN RN4
, PAA.RN RN3
, MASIS.RN RN2
, MP.RN RN1
FROM MRP_AP_ASL_SN PASLVV
, MRP_AP_ASL_ATTRS_SN PAA
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MASIS
WHERE MASIS.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND PASLVV.ITEM_ID= MASIS.INVENTORY_ITEM_ID
AND PASLVV.USING_ORGANIZATION_ID= -1
AND PAA.ASL_ID= PASLVV.ASL_ID
AND PAA.USING_ORGANIZATION_ID= PASLVV.USING_ORGANIZATION_ID
AND PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING'
, PAA.VENDOR_ID
, PAA.VENDOR_SITE_ID
, MASIS.INVENTORY_ITEM_ID
, NULL
, NULL) != 0
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
USING_ORGANIZATION_ID |
ASL_ID |
PROCESSING_LEAD_TIME |
MINIMUM_ORDER_QUANTITY |
FIXED_LOT_MULTIPLE |
DELIVERY_CALENDAR_CODE |
VENDOR_ID |
VENDOR_SITE_ID |
RN4 |
RN3 |
RN2 |
RN1 |