VIEW: APPS.PO_LINE_LOCATIONS_REF_V

Source

View Text - Preformatted

SELECT PLL.LINE_LOCATION_ID, PLL.SHIPMENT_NUM, PLL.TRANSACTION_FLOW_HEADER_ID, PLL.DROP_SHIP_FLAG, PLL.SHIP_TO_ORGANIZATION_ID, MP.ORGANIZATION_CODE, PLL.MATCH_OPTION, PLL.RECEIVING_ROUTING_ID, Decode (NVL(pll.receipt_required_flag, 'N'), 'N', '2WAY', 'Y', (Decode (NVL(pll.inspection_required_flag, 'N'), 'N', '3WAY', 'Y', '4WAY' ) )) , PLL.DESCRIPTION, PLL.ATTRIBUTE_CATEGORY, PLL.ATTRIBUTE1, PLL.ATTRIBUTE2, PLL.ATTRIBUTE3, PLL.ATTRIBUTE4, PLL.ATTRIBUTE5, PLL.ATTRIBUTE6, PLL.ATTRIBUTE7, PLL.ATTRIBUTE8, PLL.ATTRIBUTE9, PLL.ATTRIBUTE10, PLL.ATTRIBUTE11, PLL.ATTRIBUTE12, PLL.ATTRIBUTE13, PLL.ATTRIBUTE14, PLL.ATTRIBUTE15, PLL.GLOBAL_ATTRIBUTE_CATEGORY, PLL.GLOBAL_ATTRIBUTE1 , PLL.GLOBAL_ATTRIBUTE2 , PLL.GLOBAL_ATTRIBUTE3 , PLL.GLOBAL_ATTRIBUTE4 , PLL.GLOBAL_ATTRIBUTE5 , PLL.GLOBAL_ATTRIBUTE6 , PLL.GLOBAL_ATTRIBUTE7 , PLL.GLOBAL_ATTRIBUTE8 , PLL.GLOBAL_ATTRIBUTE9 , PLL.GLOBAL_ATTRIBUTE10 , PLL.GLOBAL_ATTRIBUTE11 , PLL.GLOBAL_ATTRIBUTE12 , PLL.GLOBAL_ATTRIBUTE13 , PLL.GLOBAL_ATTRIBUTE14 , PLL.GLOBAL_ATTRIBUTE15 , PLL.GLOBAL_ATTRIBUTE16 , PLL.GLOBAL_ATTRIBUTE17 , PLL.GLOBAL_ATTRIBUTE18 , PLL.GLOBAL_ATTRIBUTE19 , PLL.GLOBAL_ATTRIBUTE20 FROM PO_LINE_LOCATIONS PLL, MTL_PARAMETERS MP WHERE PLL.SHIP_TO_ORGANIZATION_ID= MP.ORGANIZATION_ID

View Text - HTML Formatted

SELECT PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, PLL.TRANSACTION_FLOW_HEADER_ID
, PLL.DROP_SHIP_FLAG
, PLL.SHIP_TO_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PLL.MATCH_OPTION
, PLL.RECEIVING_ROUTING_ID
, DECODE (NVL(PLL.RECEIPT_REQUIRED_FLAG
, 'N')
, 'N'
, '2WAY'
, 'Y'
, (DECODE (NVL(PLL.INSPECTION_REQUIRED_FLAG
, 'N')
, 'N'
, '3WAY'
, 'Y'
, '4WAY' ) ))
, PLL.DESCRIPTION
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE_CATEGORY
, PLL.GLOBAL_ATTRIBUTE1
, PLL.GLOBAL_ATTRIBUTE2
, PLL.GLOBAL_ATTRIBUTE3
, PLL.GLOBAL_ATTRIBUTE4
, PLL.GLOBAL_ATTRIBUTE5
, PLL.GLOBAL_ATTRIBUTE6
, PLL.GLOBAL_ATTRIBUTE7
, PLL.GLOBAL_ATTRIBUTE8
, PLL.GLOBAL_ATTRIBUTE9
, PLL.GLOBAL_ATTRIBUTE10
, PLL.GLOBAL_ATTRIBUTE11
, PLL.GLOBAL_ATTRIBUTE12
, PLL.GLOBAL_ATTRIBUTE13
, PLL.GLOBAL_ATTRIBUTE14
, PLL.GLOBAL_ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE16
, PLL.GLOBAL_ATTRIBUTE17
, PLL.GLOBAL_ATTRIBUTE18
, PLL.GLOBAL_ATTRIBUTE19
, PLL.GLOBAL_ATTRIBUTE20
FROM PO_LINE_LOCATIONS PLL
, MTL_PARAMETERS MP
WHERE PLL.SHIP_TO_ORGANIZATION_ID= MP.ORGANIZATION_ID