VIEW: APPS.ICX_POR_SEARCH_ASLS_V

Source

View Text - Preformatted

SELECT pasl.asl_id por_asl_id, to_char(null) por_template_name, to_number(null) por_template_line_num, to_char(null) por_reserve_po_number, to_date(null) por_template_inactive_date, to_char(null) por_rfq_required_flag, to_number(null) por_line_type_id, to_char(null) por_line_type, to_char(null) por_order_type_code, to_char(null) por_order_type, pasl.item_id por_item_id, msik.description por_item_description, msik.concatenated_segments por_item_num, to_char(null) por_item_revision, msik.attribute14 por_item_url, msik.full_lead_time por_item_lt, msik.purchasing_enabled_flag por_item_purchasable_flag, msik.inventory_item_flag por_item_inventory_flag, msik.must_use_approved_vendor_flag por_use_approved_supplier, pasl.category_id por_category_id, mck.concatenated_segments por_category, mck.description por_category_desc, pasl.vendor_id por_supplier_id, pv.vendor_name por_suppl_name, pasl.vendor_site_id por_supplier_site_id, pvs.vendor_site_code por_suppl_site, to_number(null) por_supplier_contact_id, to_char(null) por_suppl_contact , to_char(null) por_suppl_contact_phone, pv.attribute14 por_suppl_url, pasl.primary_vendor_item por_suppl_item_num, to_char(null) por_suppl_item_url, pv.hold_flag por_suppl_hold_flag, to_char(null) por_manufacturer_name, to_char(null) por_manufacturer_part_num, paa.purchasing_unit_of_measure por_unit_of_measure, gsb.currency_code por_currency_code, to_number(null) por_currency_line_price, to_char(null) por_foreign_currency_code, to_char(null) por_rate_type, to_char(null) por_foreign_currency_rate_type, to_date(null) por_foreign_currency_rate_date, to_number(null) por_foreign_currency_rate, to_number(null) por_unit_price, to_char(null) por_type_lookup_code, to_char(null) por_source_doc_type_code, to_number(null) por_po_header_id, to_char(null) por_source_doc_num, to_number(null) por_po_line_id, to_number(null) por_source_doc_line_num, to_date(null) por_source_doc_effective_from, to_date(null) por_source_doc_effective_to, to_number(null) por_source_doc_amount_agreed, to_number(null) por_source_doc_amount_limit, to_number(null) por_source_doc_min_release_amt, to_number(null) por_source_doc_quantity_agreed, to_number(null) por_source_doc_min_order_qty, to_number(null) por_source_doc_max_order_qty, to_number(null) por_terms_id, to_number(null) por_payment_terms, to_char(null) por_ship_via_lookup_code, to_char(null) por_ship_via, to_char(null) por_freight_terms_lookup_code, to_char(null) por_freight_terms, to_char(null) por_fob_lookup_code, to_char(null) por_fob, to_number(null) por_agent_id, to_char(null) por_buyer_name, to_char(null) por_cattribute1, to_char(null) por_cattribute2, to_char(null) por_cattribute3, to_char(null) por_cattribute4, to_char(null) por_cattribute5, to_char(null) por_cattribute6, to_char(null) por_cattribute7, to_char(null) por_cattribute8, to_char(null) por_cattribute9, to_char(null) por_cattribute10, to_char(null) por_cattribute11, to_char(null) por_cattribute12, to_char(null) por_cattribute13, to_char(null) por_cattribute14, to_char(null) por_cattribute15, to_char(null) por_tattribute1, to_char(null) por_tattribute2, to_char(null) por_tattribute3, to_char(null) por_tattribute4, to_char(null) por_tattribute5, to_char(null) por_tattribute6, to_char(null) por_tattribute7, to_char(null) por_tattribute8, to_char(null) por_tattribute9, to_char(null) por_tattribute10, to_char(null) por_tattribute11, to_char(null) por_tattribute12, to_char(null) por_tattribute13, to_char(null) por_tattribute14, to_char(null) por_tattribute15, pasl.attribute1 por_aattribute1, pasl.attribute2 por_aattribute2, pasl.attribute3 por_aattribute3, pasl.attribute4 por_aattribute4, pasl.attribute5 por_aattribute5, pasl.attribute6 por_aattribute6, pasl.attribute7 por_aattribute7, pasl.attribute8 por_aattribute8, pasl.attribute9 por_aattribute9, pasl.attribute10 por_aattribute10, pasl.attribute11 por_aattribute11, pasl.attribute12 por_aattribute12, pasl.attribute13 por_aattribute13, pasl.attribute14 por_aattribute14, pasl.attribute15 por_aattribute15, to_char(null) por_iattribute1, to_char(null) por_iattribute2, to_char(null) por_iattribute3, to_char(null) por_iattribute4, to_char(null) por_iattribute5, to_char(null) por_iattribute6, to_char(null) por_iattribute7, to_char(null) por_iattribute8, to_char(null) por_iattribute9, to_char(null) por_iattribute10, to_char(null) por_iattribute11, to_char(null) por_iattribute12, to_char(null) por_iattribute13, to_char(null) por_iattribute14, to_char(null) por_iattribute15 from mtl_system_items_kfv msik, po_vendor_sites pvs, po_vendors pv, gl_sets_of_books gsb, financials_system_parameters fsp, mtl_categories_kfv mck, po_asl_attributes paa, po_approved_supplier_list pasl WHERE pasl.item_id is not null and pasl.asl_id = paa.asl_id and mck.category_id (+) = pasl.category_id and gsb.set_of_books_id = fsp.set_of_books_id and pasl.vendor_id = pv.vendor_id and pasl.vendor_site_id = pvs.vendor_site_id (+) and msik.organization_id = pasl.owning_organization_id and msik.inventory_item_id = pasl.item_id

View Text - HTML Formatted

SELECT PASL.ASL_ID POR_ASL_ID
, TO_CHAR(NULL) POR_TEMPLATE_NAME
, TO_NUMBER(NULL) POR_TEMPLATE_LINE_NUM
, TO_CHAR(NULL) POR_RESERVE_PO_NUMBER
, TO_DATE(NULL) POR_TEMPLATE_INACTIVE_DATE
, TO_CHAR(NULL) POR_RFQ_REQUIRED_FLAG
, TO_NUMBER(NULL) POR_LINE_TYPE_ID
, TO_CHAR(NULL) POR_LINE_TYPE
, TO_CHAR(NULL) POR_ORDER_TYPE_CODE
, TO_CHAR(NULL) POR_ORDER_TYPE
, PASL.ITEM_ID POR_ITEM_ID
, MSIK.DESCRIPTION POR_ITEM_DESCRIPTION
, MSIK.CONCATENATED_SEGMENTS POR_ITEM_NUM
, TO_CHAR(NULL) POR_ITEM_REVISION
, MSIK.ATTRIBUTE14 POR_ITEM_URL
, MSIK.FULL_LEAD_TIME POR_ITEM_LT
, MSIK.PURCHASING_ENABLED_FLAG POR_ITEM_PURCHASABLE_FLAG
, MSIK.INVENTORY_ITEM_FLAG POR_ITEM_INVENTORY_FLAG
, MSIK.MUST_USE_APPROVED_VENDOR_FLAG POR_USE_APPROVED_SUPPLIER
, PASL.CATEGORY_ID POR_CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS POR_CATEGORY
, MCK.DESCRIPTION POR_CATEGORY_DESC
, PASL.VENDOR_ID POR_SUPPLIER_ID
, PV.VENDOR_NAME POR_SUPPL_NAME
, PASL.VENDOR_SITE_ID POR_SUPPLIER_SITE_ID
, PVS.VENDOR_SITE_CODE POR_SUPPL_SITE
, TO_NUMBER(NULL) POR_SUPPLIER_CONTACT_ID
, TO_CHAR(NULL) POR_SUPPL_CONTACT
, TO_CHAR(NULL) POR_SUPPL_CONTACT_PHONE
, PV.ATTRIBUTE14 POR_SUPPL_URL
, PASL.PRIMARY_VENDOR_ITEM POR_SUPPL_ITEM_NUM
, TO_CHAR(NULL) POR_SUPPL_ITEM_URL
, PV.HOLD_FLAG POR_SUPPL_HOLD_FLAG
, TO_CHAR(NULL) POR_MANUFACTURER_NAME
, TO_CHAR(NULL) POR_MANUFACTURER_PART_NUM
, PAA.PURCHASING_UNIT_OF_MEASURE POR_UNIT_OF_MEASURE
, GSB.CURRENCY_CODE POR_CURRENCY_CODE
, TO_NUMBER(NULL) POR_CURRENCY_LINE_PRICE
, TO_CHAR(NULL) POR_FOREIGN_CURRENCY_CODE
, TO_CHAR(NULL) POR_RATE_TYPE
, TO_CHAR(NULL) POR_FOREIGN_CURRENCY_RATE_TYPE
, TO_DATE(NULL) POR_FOREIGN_CURRENCY_RATE_DATE
, TO_NUMBER(NULL) POR_FOREIGN_CURRENCY_RATE
, TO_NUMBER(NULL) POR_UNIT_PRICE
, TO_CHAR(NULL) POR_TYPE_LOOKUP_CODE
, TO_CHAR(NULL) POR_SOURCE_DOC_TYPE_CODE
, TO_NUMBER(NULL) POR_PO_HEADER_ID
, TO_CHAR(NULL) POR_SOURCE_DOC_NUM
, TO_NUMBER(NULL) POR_PO_LINE_ID
, TO_NUMBER(NULL) POR_SOURCE_DOC_LINE_NUM
, TO_DATE(NULL) POR_SOURCE_DOC_EFFECTIVE_FROM
, TO_DATE(NULL) POR_SOURCE_DOC_EFFECTIVE_TO
, TO_NUMBER(NULL) POR_SOURCE_DOC_AMOUNT_AGREED
, TO_NUMBER(NULL) POR_SOURCE_DOC_AMOUNT_LIMIT
, TO_NUMBER(NULL) POR_SOURCE_DOC_MIN_RELEASE_AMT
, TO_NUMBER(NULL) POR_SOURCE_DOC_QUANTITY_AGREED
, TO_NUMBER(NULL) POR_SOURCE_DOC_MIN_ORDER_QTY
, TO_NUMBER(NULL) POR_SOURCE_DOC_MAX_ORDER_QTY
, TO_NUMBER(NULL) POR_TERMS_ID
, TO_NUMBER(NULL) POR_PAYMENT_TERMS
, TO_CHAR(NULL) POR_SHIP_VIA_LOOKUP_CODE
, TO_CHAR(NULL) POR_SHIP_VIA
, TO_CHAR(NULL) POR_FREIGHT_TERMS_LOOKUP_CODE
, TO_CHAR(NULL) POR_FREIGHT_TERMS
, TO_CHAR(NULL) POR_FOB_LOOKUP_CODE
, TO_CHAR(NULL) POR_FOB
, TO_NUMBER(NULL) POR_AGENT_ID
, TO_CHAR(NULL) POR_BUYER_NAME
, TO_CHAR(NULL) POR_CATTRIBUTE1
, TO_CHAR(NULL) POR_CATTRIBUTE2
, TO_CHAR(NULL) POR_CATTRIBUTE3
, TO_CHAR(NULL) POR_CATTRIBUTE4
, TO_CHAR(NULL) POR_CATTRIBUTE5
, TO_CHAR(NULL) POR_CATTRIBUTE6
, TO_CHAR(NULL) POR_CATTRIBUTE7
, TO_CHAR(NULL) POR_CATTRIBUTE8
, TO_CHAR(NULL) POR_CATTRIBUTE9
, TO_CHAR(NULL) POR_CATTRIBUTE10
, TO_CHAR(NULL) POR_CATTRIBUTE11
, TO_CHAR(NULL) POR_CATTRIBUTE12
, TO_CHAR(NULL) POR_CATTRIBUTE13
, TO_CHAR(NULL) POR_CATTRIBUTE14
, TO_CHAR(NULL) POR_CATTRIBUTE15
, TO_CHAR(NULL) POR_TATTRIBUTE1
, TO_CHAR(NULL) POR_TATTRIBUTE2
, TO_CHAR(NULL) POR_TATTRIBUTE3
, TO_CHAR(NULL) POR_TATTRIBUTE4
, TO_CHAR(NULL) POR_TATTRIBUTE5
, TO_CHAR(NULL) POR_TATTRIBUTE6
, TO_CHAR(NULL) POR_TATTRIBUTE7
, TO_CHAR(NULL) POR_TATTRIBUTE8
, TO_CHAR(NULL) POR_TATTRIBUTE9
, TO_CHAR(NULL) POR_TATTRIBUTE10
, TO_CHAR(NULL) POR_TATTRIBUTE11
, TO_CHAR(NULL) POR_TATTRIBUTE12
, TO_CHAR(NULL) POR_TATTRIBUTE13
, TO_CHAR(NULL) POR_TATTRIBUTE14
, TO_CHAR(NULL) POR_TATTRIBUTE15
, PASL.ATTRIBUTE1 POR_AATTRIBUTE1
, PASL.ATTRIBUTE2 POR_AATTRIBUTE2
, PASL.ATTRIBUTE3 POR_AATTRIBUTE3
, PASL.ATTRIBUTE4 POR_AATTRIBUTE4
, PASL.ATTRIBUTE5 POR_AATTRIBUTE5
, PASL.ATTRIBUTE6 POR_AATTRIBUTE6
, PASL.ATTRIBUTE7 POR_AATTRIBUTE7
, PASL.ATTRIBUTE8 POR_AATTRIBUTE8
, PASL.ATTRIBUTE9 POR_AATTRIBUTE9
, PASL.ATTRIBUTE10 POR_AATTRIBUTE10
, PASL.ATTRIBUTE11 POR_AATTRIBUTE11
, PASL.ATTRIBUTE12 POR_AATTRIBUTE12
, PASL.ATTRIBUTE13 POR_AATTRIBUTE13
, PASL.ATTRIBUTE14 POR_AATTRIBUTE14
, PASL.ATTRIBUTE15 POR_AATTRIBUTE15
, TO_CHAR(NULL) POR_IATTRIBUTE1
, TO_CHAR(NULL) POR_IATTRIBUTE2
, TO_CHAR(NULL) POR_IATTRIBUTE3
, TO_CHAR(NULL) POR_IATTRIBUTE4
, TO_CHAR(NULL) POR_IATTRIBUTE5
, TO_CHAR(NULL) POR_IATTRIBUTE6
, TO_CHAR(NULL) POR_IATTRIBUTE7
, TO_CHAR(NULL) POR_IATTRIBUTE8
, TO_CHAR(NULL) POR_IATTRIBUTE9
, TO_CHAR(NULL) POR_IATTRIBUTE10
, TO_CHAR(NULL) POR_IATTRIBUTE11
, TO_CHAR(NULL) POR_IATTRIBUTE12
, TO_CHAR(NULL) POR_IATTRIBUTE13
, TO_CHAR(NULL) POR_IATTRIBUTE14
, TO_CHAR(NULL) POR_IATTRIBUTE15
FROM MTL_SYSTEM_ITEMS_KFV MSIK
, PO_VENDOR_SITES PVS
, PO_VENDORS PV
, GL_SETS_OF_BOOKS GSB
, FINANCIALS_SYSTEM_PARAMETERS FSP
, MTL_CATEGORIES_KFV MCK
, PO_ASL_ATTRIBUTES PAA
, PO_APPROVED_SUPPLIER_LIST PASL
WHERE PASL.ITEM_ID IS NOT NULL
AND PASL.ASL_ID = PAA.ASL_ID
AND MCK.CATEGORY_ID (+) = PASL.CATEGORY_ID
AND GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND PASL.VENDOR_ID = PV.VENDOR_ID
AND PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND MSIK.ORGANIZATION_ID = PASL.OWNING_ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = PASL.ITEM_ID