VIEW: APPS.ASO_PVT_INSTALL_BASE_BALI_V

Source

View Text - Preformatted

SELECT cii.instance_id, cii.instance_number , cii.serial_number , cii.quantity , cii.unit_of_measure , csv.system_id , csv.name , msiv.inventory_item_id , msiv.organization_id , msiv.concatenated_segments , msiv.description ,msiv.base_item_id , msiv.bom_item_type ,msiv.serviceable_product_flag , cii.owner_party_account_id , oh.order_number , oh.ordered_date ordered_date , cii.install_location_type_code , cii.install_location_id FROM csi_item_instances cii , csi_systems_vl csv , mtl_system_items_vl msiv , oe_order_lines_all ol , oe_order_headers oh WHERE cii.last_oe_order_line_id = ol.line_id(+) AND ol.header_id = oh.header_id(+) AND cii.system_id = csv.system_id(+) AND cii.inventory_item_id = msiv.inventory_item_id AND cii.inv_master_organization_id = msiv.organization_id AND ol.org_id = oh.org_id(+)

View Text - HTML Formatted

SELECT CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.SERIAL_NUMBER
, CII.QUANTITY
, CII.UNIT_OF_MEASURE
, CSV.SYSTEM_ID
, CSV.NAME
, MSIV.INVENTORY_ITEM_ID
, MSIV.ORGANIZATION_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV.DESCRIPTION
, MSIV.BASE_ITEM_ID
, MSIV.BOM_ITEM_TYPE
, MSIV.SERVICEABLE_PRODUCT_FLAG
, CII.OWNER_PARTY_ACCOUNT_ID
, OH.ORDER_NUMBER
, OH.ORDERED_DATE ORDERED_DATE
, CII.INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID
FROM CSI_ITEM_INSTANCES CII
, CSI_SYSTEMS_VL CSV
, MTL_SYSTEM_ITEMS_VL MSIV
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS OH
WHERE CII.LAST_OE_ORDER_LINE_ID = OL.LINE_ID(+)
AND OL.HEADER_ID = OH.HEADER_ID(+)
AND CII.SYSTEM_ID = CSV.SYSTEM_ID(+)
AND CII.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND CII.INV_MASTER_ORGANIZATION_ID = MSIV.ORGANIZATION_ID
AND OL.ORG_ID = OH.ORG_ID(+)