VIEW: APPS.PO_REQUISITION_LINES_CLM_V

Source

View Text - Preformatted

SELECT REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LINE_TYPE_ID,CATEGORY_ID,ITEM_DESCRIPTION,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,SOURCE_TYPE_CODE,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,ITEM_ID,ITEM_REVISION,QUANTITY_DELIVERED,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,LINE_LOCATION_ID,MODIFIED_BY_AGENT_FLAG,PARENT_REQ_LINE_ID,JUSTIFICATION,NOTE_TO_AGENT,NOTE_TO_RECEIVER,PURCHASING_AGENT_ID,DOCUMENT_TYPE_CODE,BLANKET_PO_HEADER_ID,BLANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION,SUGGESTED_VENDOR_CONTACT,SUGGESTED_VENDOR_PHONE,SUGGESTED_VENDOR_PRODUCT_CODE,UN_NUMBER_ID,HAZARD_CLASS_ID,MUST_USE_SUGG_VENDOR_FLAG,REFERENCE_NUM,ON_RFQ_FLAG,URGENT_FLAG,CANCEL_FLAG,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,DESTINATION_TYPE_CODE,DESTINATION_ORGANIZATION_ID,DESTINATION_SUBINVENTORY,QUANTITY_CANCELLED,CANCEL_DATE,CANCEL_REASON,CLOSED_CODE,AGENT_RETURN_NOTE,CHANGED_AFTER_RESEARCH_FLAG,VENDOR_ID,VENDOR_SITE_ID,VENDOR_CONTACT_ID,RESEARCH_AGENT_ID,ON_LINE_FLAG,WIP_ENTITY_ID,WIP_LINE_ID,WIP_REPETITIVE_SCHEDULE_ID,WIP_OPERATION_SEQ_NUM,WIP_RESOURCE_SEQ_NUM,ATTRIBUTE_CATEGORY,DESTINATION_CONTEXT,INVENTORY_SOURCE_CONTEXT,VENDOR_SOURCE_CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,BOM_RESOURCE_ID,REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,USSGL_TRANSACTION_CODE,GOVERNMENT_CONTEXT,CLOSED_REASON,CLOSED_DATE,TRANSACTION_REASON_CODE,QUANTITY_RECEIVED,SOURCE_REQ_LINE_ID,ORG_ID,GLOBAL_ATTRIBUTE1,GLOBAL_ATTRIBUTE2,GLOBAL_ATTRIBUTE3,GLOBAL_ATTRIBUTE4,GLOBAL_ATTRIBUTE5,GLOBAL_ATTRIBUTE6,GLOBAL_ATTRIBUTE7,GLOBAL_ATTRIBUTE8,GLOBAL_ATTRIBUTE9,GLOBAL_ATTRIBUTE10,GLOBAL_ATTRIBUTE11,GLOBAL_ATTRIBUTE12,GLOBAL_ATTRIBUTE13,GLOBAL_ATTRIBUTE14,GLOBAL_ATTRIBUTE15,GLOBAL_ATTRIBUTE16,GLOBAL_ATTRIBUTE17,GLOBAL_ATTRIBUTE18,GLOBAL_ATTRIBUTE19,GLOBAL_ATTRIBUTE20,GLOBAL_ATTRIBUTE_CATEGORY,KANBAN_CARD_ID,CATALOG_TYPE,CATALOG_SOURCE,MANUFACTURER_ID,MANUFACTURER_NAME,MANUFACTURER_PART_NUMBER,REQUESTER_EMAIL,REQUESTER_FAX,REQUESTER_PHONE,UNSPSC_CODE,OTHER_CATEGORY_CODE,SUPPLIER_DUNS,TAX_STATUS_INDICATOR,PCARD_FLAG,NEW_SUPPLIER_FLAG,AUTO_RECEIVE_FLAG,TAX_USER_OVERRIDE_FLAG,TAX_CODE_ID,NOTE_TO_VENDOR,OKE_CONTRACT_VERSION_ID,OKE_CONTRACT_HEADER_ID,ITEM_SOURCE_ID,SUPPLIER_REF_NUMBER,SECONDARY_UNIT_OF_MEASURE,SECONDARY_QUANTITY,PREFERRED_GRADE,SECONDARY_QUANTITY_RECEIVED,SECONDARY_QUANTITY_CANCELLED,VMI_FLAG,AUCTION_HEADER_ID,AUCTION_DISPLAY_NUMBER,AUCTION_LINE_NUMBER,REQS_IN_POOL_FLAG,BID_NUMBER,BID_LINE_NUMBER,NONCAT_TEMPLATE_ID,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,AMOUNT,CURRENCY_AMOUNT,LABOR_REQ_LINE_ID,JOB_ID,JOB_LONG_DESCRIPTION,CONTRACTOR_STATUS,CONTACT_INFORMATION,SUGGESTED_SUPPLIER_FLAG,CANDIDATE_SCREENING_REQD_FLAG,ASSIGNMENT_END_DATE,OVERTIME_ALLOWED_FLAG,CONTRACTOR_REQUISITION_FLAG,DROP_SHIP_FLAG,CANDIDATE_FIRST_NAME,CANDIDATE_LAST_NAME,ASSIGNMENT_START_DATE,ORDER_TYPE_LOOKUP_CODE,PURCHASE_BASIS,MATCHING_BASIS,NEGOTIATED_BY_PREPARER_FLAG,SHIP_METHOD,ESTIMATED_PICKUP_DATE,SUPPLIER_NOTIFIED_FOR_CANCEL,BASE_UNIT_PRICE,AT_SOURCING_FLAG,TAX_ATTRIBUTE_UPDATE_CODE,TAX_NAME,LINE_NUM_DISPLAY,GROUP_LINE_ID,CLM_INFO_FLAG,CLM_OPTION_INDICATOR,CLM_OPTION_NUM,CLM_OPTION_FROM_DATE,CLM_OPTION_TO_DATE,CLM_FUNDED_FLAG,CLM_BASE_LINE_NUM,CONFORMED_LINE_ID,AMENDMENT_TYPE,AMENDMENT_STATUS,COST_CONSTRAINT,CONTRACT_TYPE,FUND_SOURCE_NOT_KNOWN FROM PO_REQUISITION_LINES WHERE Nvl(CLM_INFO_FLAG,'N')='N'

View Text - HTML Formatted

SELECT REQUISITION_LINE_ID
, REQUISITION_HEADER_ID
, LINE_NUM
, LINE_TYPE_ID
, CATEGORY_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, QUANTITY
, DELIVER_TO_LOCATION_ID
, TO_PERSON_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SOURCE_TYPE_CODE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ITEM_ID
, ITEM_REVISION
, QUANTITY_DELIVERED
, SUGGESTED_BUYER_ID
, ENCUMBERED_FLAG
, RFQ_REQUIRED_FLAG
, NEED_BY_DATE
, LINE_LOCATION_ID
, MODIFIED_BY_AGENT_FLAG
, PARENT_REQ_LINE_ID
, JUSTIFICATION
, NOTE_TO_AGENT
, NOTE_TO_RECEIVER
, PURCHASING_AGENT_ID
, DOCUMENT_TYPE_CODE
, BLANKET_PO_HEADER_ID
, BLANKET_PO_LINE_NUM
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, RATE
, CURRENCY_UNIT_PRICE
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_PRODUCT_CODE
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, MUST_USE_SUGG_VENDOR_FLAG
, REFERENCE_NUM
, ON_RFQ_FLAG
, URGENT_FLAG
, CANCEL_FLAG
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY
, QUANTITY_CANCELLED
, CANCEL_DATE
, CANCEL_REASON
, CLOSED_CODE
, AGENT_RETURN_NOTE
, CHANGED_AFTER_RESEARCH_FLAG
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, RESEARCH_AGENT_ID
, ON_LINE_FLAG
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, ATTRIBUTE_CATEGORY
, DESTINATION_CONTEXT
, INVENTORY_SOURCE_CONTEXT
, VENDOR_SOURCE_CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, BOM_RESOURCE_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, CLOSED_REASON
, CLOSED_DATE
, TRANSACTION_REASON_CODE
, QUANTITY_RECEIVED
, SOURCE_REQ_LINE_ID
, ORG_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, KANBAN_CARD_ID
, CATALOG_TYPE
, CATALOG_SOURCE
, MANUFACTURER_ID
, MANUFACTURER_NAME
, MANUFACTURER_PART_NUMBER
, REQUESTER_EMAIL
, REQUESTER_FAX
, REQUESTER_PHONE
, UNSPSC_CODE
, OTHER_CATEGORY_CODE
, SUPPLIER_DUNS
, TAX_STATUS_INDICATOR
, PCARD_FLAG
, NEW_SUPPLIER_FLAG
, AUTO_RECEIVE_FLAG
, TAX_USER_OVERRIDE_FLAG
, TAX_CODE_ID
, NOTE_TO_VENDOR
, OKE_CONTRACT_VERSION_ID
, OKE_CONTRACT_HEADER_ID
, ITEM_SOURCE_ID
, SUPPLIER_REF_NUMBER
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_CANCELLED
, VMI_FLAG
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, REQS_IN_POOL_FLAG
, BID_NUMBER
, BID_LINE_NUMBER
, NONCAT_TEMPLATE_ID
, SUGGESTED_VENDOR_CONTACT_FAX
, SUGGESTED_VENDOR_CONTACT_EMAIL
, AMOUNT
, CURRENCY_AMOUNT
, LABOR_REQ_LINE_ID
, JOB_ID
, JOB_LONG_DESCRIPTION
, CONTRACTOR_STATUS
, CONTACT_INFORMATION
, SUGGESTED_SUPPLIER_FLAG
, CANDIDATE_SCREENING_REQD_FLAG
, ASSIGNMENT_END_DATE
, OVERTIME_ALLOWED_FLAG
, CONTRACTOR_REQUISITION_FLAG
, DROP_SHIP_FLAG
, CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME
, ASSIGNMENT_START_DATE
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, NEGOTIATED_BY_PREPARER_FLAG
, SHIP_METHOD
, ESTIMATED_PICKUP_DATE
, SUPPLIER_NOTIFIED_FOR_CANCEL
, BASE_UNIT_PRICE
, AT_SOURCING_FLAG
, TAX_ATTRIBUTE_UPDATE_CODE
, TAX_NAME
, LINE_NUM_DISPLAY
, GROUP_LINE_ID
, CLM_INFO_FLAG
, CLM_OPTION_INDICATOR
, CLM_OPTION_NUM
, CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG
, CLM_BASE_LINE_NUM
, CONFORMED_LINE_ID
, AMENDMENT_TYPE
, AMENDMENT_STATUS
, COST_CONSTRAINT
, CONTRACT_TYPE
, FUND_SOURCE_NOT_KNOWN
FROM PO_REQUISITION_LINES
WHERE NVL(CLM_INFO_FLAG
, 'N')='N'