VIEW: APPS.CSP_SEC_INVENTORIES_V

Source

View Text - Preformatted

SELECT B.ROWID, B.SECONDARY_INVENTORY_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ORGANIZATION_ID, B.PARTS_LOOP_ID, B.HIERARCHY_NODE_ID, MTL.LOCATION_ID, B.CONDITION_TYPE, B.AUTORECEIPT_FLAG, B.SPARES_LOCATION_FLAG, hl.location_code, hl.style, hl.address_line_1, hl.address_line_2, hl.address_line_3, hl.country, HL.LOC_INFORMATION13 , HL.LOC_INFORMATION14 , HL.LOC_INFORMATION15 , HL.LOC_INFORMATION16 , HL.LOC_INFORMATION17 , HL.LOC_INFORMATION18 , HL.LOC_INFORMATION19 , HL.LOC_INFORMATION20 , HL.POSTAL_CODE , HL.REGION_1 , HL.REGION_2 , HL.REGION_3 , HL.TELEPHONE_NUMBER_1 , HL.TELEPHONE_NUMBER_2 , HL.TELEPHONE_NUMBER_3 , HL.TOWN_OR_CITY , HL.BILL_TO_SITE_FLAG , HL.DESCRIPTION , HL.DESIGNATED_RECEIVER_ID , HL.ECE_TP_LOCATION_CODE , HL.INACTIVE_DATE , HL.ENTERED_BY , HL.INVENTORY_ORGANIZATION_ID , HL.IN_ORGANIZATION_FLAG , HL.OFFICE_SITE_FLAG , HL.RECEIVING_SITE_FLAG , HL.SHIP_TO_LOCATION_ID , HL.SHIP_TO_SITE_FLAG , HL.TAX_NAME , HL.TP_HEADER_ID , B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.SECONDARY_INVENTORY_NAME, L.MEANING, B.RETURN_ORGANIZATION_ID, B.RETURN_SUBINVENTORY_NAME, OD.ORGANIZATION_NAME, OD.ORGANIZATION_CODE, B.OWNER_RESOURCE_TYPE, B.OWNER_RESOURCE_ID, ftv.territory_short_name from CSP_SEC_INVENTORIES B, FND_LOOKUPS L, ORG_ORGANIZATION_DEFINITIONS OD, FND_TERRITORIES_VL FTV, hr_locations_all hl, MTL_SECONDARY_INVENTORIES MTL Where mtl.secondary_inventory_name=b.secondary_inventory_name and mtl.organization_id = b.organization_id and mtl.location_id = hl.location_id(+) and B.CONDITION_TYPE = L.LOOKUP_CODE and L.LOOKUP_TYPE like 'CSP_CONDITION_TYPE' and B.ORGANIZATION_ID = OD.ORGANIZATION_ID and hl.country = ftv.territory_code(+)

View Text - HTML Formatted

SELECT B.ROWID
, B.SECONDARY_INVENTORY_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.ORGANIZATION_ID
, B.PARTS_LOOP_ID
, B.HIERARCHY_NODE_ID
, MTL.LOCATION_ID
, B.CONDITION_TYPE
, B.AUTORECEIPT_FLAG
, B.SPARES_LOCATION_FLAG
, HL.LOCATION_CODE
, HL.STYLE
, HL.ADDRESS_LINE_1
, HL.ADDRESS_LINE_2
, HL.ADDRESS_LINE_3
, HL.COUNTRY
, HL.LOC_INFORMATION13
, HL.LOC_INFORMATION14
, HL.LOC_INFORMATION15
, HL.LOC_INFORMATION16
, HL.LOC_INFORMATION17
, HL.LOC_INFORMATION18
, HL.LOC_INFORMATION19
, HL.LOC_INFORMATION20
, HL.POSTAL_CODE
, HL.REGION_1
, HL.REGION_2
, HL.REGION_3
, HL.TELEPHONE_NUMBER_1
, HL.TELEPHONE_NUMBER_2
, HL.TELEPHONE_NUMBER_3
, HL.TOWN_OR_CITY
, HL.BILL_TO_SITE_FLAG
, HL.DESCRIPTION
, HL.DESIGNATED_RECEIVER_ID
, HL.ECE_TP_LOCATION_CODE
, HL.INACTIVE_DATE
, HL.ENTERED_BY
, HL.INVENTORY_ORGANIZATION_ID
, HL.IN_ORGANIZATION_FLAG
, HL.OFFICE_SITE_FLAG
, HL.RECEIVING_SITE_FLAG
, HL.SHIP_TO_LOCATION_ID
, HL.SHIP_TO_SITE_FLAG
, HL.TAX_NAME
, HL.TP_HEADER_ID
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.SECONDARY_INVENTORY_NAME
, L.MEANING
, B.RETURN_ORGANIZATION_ID
, B.RETURN_SUBINVENTORY_NAME
, OD.ORGANIZATION_NAME
, OD.ORGANIZATION_CODE
, B.OWNER_RESOURCE_TYPE
, B.OWNER_RESOURCE_ID
, FTV.TERRITORY_SHORT_NAME
FROM CSP_SEC_INVENTORIES B
, FND_LOOKUPS L
, ORG_ORGANIZATION_DEFINITIONS OD
, FND_TERRITORIES_VL FTV
, HR_LOCATIONS_ALL HL
, MTL_SECONDARY_INVENTORIES MTL
WHERE MTL.SECONDARY_INVENTORY_NAME=B.SECONDARY_INVENTORY_NAME
AND MTL.ORGANIZATION_ID = B.ORGANIZATION_ID
AND MTL.LOCATION_ID = HL.LOCATION_ID(+)
AND B.CONDITION_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE LIKE 'CSP_CONDITION_TYPE'
AND B.ORGANIZATION_ID = OD.ORGANIZATION_ID
AND HL.COUNTRY = FTV.TERRITORY_CODE(+)