Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_AK_INVENTORY_ITEMS_V |
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
, A.COVERAGE_SCHEDULE_ID TEMPLATE
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