VIEW: APPS.OE_AK_INVENTORY_ITEMS_V

Source

View Text - Preformatted

SELECT a.INVENTORY_ITEM_ID , b. ORGANIZATION_ID , a.INVOICING_RULE_ID , a.ACCOUNTING_RULE_ID , a. DEFAULT_SHIPPING_ORG , a.SHIP_MODEL_COMPLETE_FLAG , a. BUILD_IN_WIP_FLAG , a. BOM_ITEM_TYPE , a.REPLENISH_TO_ORDER_FLAG , a.PRIMARY_UOM_CODE , a.PICK_COMPONENTS_FLAG , a.OVER_SHIPMENT_TOLERANCE , a.UNDER_SHIPMENT_TOLERANCE , a.OVER_RETURN_TOLERANCE , a.UNDER_RETURN_TOLERANCE , a.PAYMENT_TERMS_ID , b.DEFAULT_SO_SOURCE_TYPE , b.CHARGE_PERIODICITY_CODE , a.SERVICE_DURATION_PERIOD_CODE , a.SERVICE_DURATION FROM MTL_SYSTEM_ITEMS A, mtl_system_items B WHERE A.ORGANIZATION_ID = OE_SYS_Parameters.Value('MASTER_ORGANIZATION_ID') and A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID

View Text - HTML Formatted

SELECT A.INVENTORY_ITEM_ID
, B. ORGANIZATION_ID
, A.INVOICING_RULE_ID
, A.ACCOUNTING_RULE_ID
, A. DEFAULT_SHIPPING_ORG
, A.SHIP_MODEL_COMPLETE_FLAG
, A. BUILD_IN_WIP_FLAG
, A. BOM_ITEM_TYPE
, A.REPLENISH_TO_ORDER_FLAG
, A.PRIMARY_UOM_CODE
, A.PICK_COMPONENTS_FLAG
, A.OVER_SHIPMENT_TOLERANCE
, A.UNDER_SHIPMENT_TOLERANCE
, A.OVER_RETURN_TOLERANCE
, A.UNDER_RETURN_TOLERANCE
, A.PAYMENT_TERMS_ID
, B.DEFAULT_SO_SOURCE_TYPE
, B.CHARGE_PERIODICITY_CODE
, A.SERVICE_DURATION_PERIOD_CODE
, A.SERVICE_DURATION
FROM MTL_SYSTEM_ITEMS A
, MTL_SYSTEM_ITEMS B
WHERE A.ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID