VIEW: APPS.PO_LINE_CHANGES_V

Source

View Text - Preformatted

SELECT "MOD_DOC_PK1_VAL", "MOD_DOC_PK2_VAL", "MOD_DOC_PK3_VAL", "ENTITY_NAME", "LINE_TYPE_ID", "LINE_NUM", "ITEM_ID", "ITEM_REVISION", "CATEGORY_ID", "ITEM_DESCRIPTION", "UNIT_MEAS_LOOKUP_CODE", "QUANTITY_COMMITTED", "COMMITTED_AMOUNT", "ALLOW_PRICE_OVERRIDE_FLAG", "NOT_TO_EXCEED_PRICE", "LIST_PRICE_PER_UNIT", "UNIT_PRICE", "QUANTITY", "UN_NUMBER_ID", "HAZARD_CLASS_ID", "NOTE_TO_VENDOR", "FROM_HEADER_ID", "FROM_LINE_ID", "MIN_ORDER_QUANTITY", "MAX_ORDER_QUANTITY", "QTY_RCV_TOLERANCE", "OVER_TOLERANCE_ERROR_FLAG", "MARKET_PRICE", "UNORDERED_FLAG", "CLOSED_FLAG", "USER_HOLD_FLAG", "CANCEL_FLAG", "CANCELLED_BY", "CANCEL_DATE", "CANCEL_REASON", "FIRM_STATUS_LOOKUP_CODE", "FIRM_DATE", "VENDOR_PRODUCT_NUM", "CONTRACT_NUM", "TAXABLE_FLAG", "TAX_NAME", "TYPE_1099", "CAPITAL_EXPENSE_FLAG", "NEGOTIATED_BY_PREPARER_FLAG", "ATTRIBUTE_CATEGORY", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "REFERENCE_NUM", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "MIN_RELEASE_AMOUNT", "PRICE_TYPE_LOOKUP_CODE", "REVISION_NUM", "PRICE_BREAK_LOOKUP_CODE", "LATEST_EXTERNAL_FLAG", "USSGL_TRANSACTION_CODE", "GOVERNMENT_CONTEXT", "REQUEST_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "CLOSED_CODE", "CLOSED_BY", "CLOSED_DATE", "CLOSED_REASON", "TRANSACTION_REASON_CODE", "ORG_ID", "GLOBAL_ATTRIBUTE_CATEGORY", "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", "EXPIRATION_DATE", "QC_GRADE", "BASE_UOM", "BASE_QTY", "SECONDARY_UOM", "SECONDARY_QTY", "LINE_REFERENCE_NUM", "PROJECT_ID", "TASK_ID", "TAX_CODE_ID", "SECONDARY_UNIT_OF_MEASURE", "SECONDARY_QUANTITY", "PREFERRED_GRADE", "AUCTION_HEADER_ID", "AUCTION_DISPLAY_NUMBER", "AUCTION_LINE_NUMBER", "BID_NUMBER", "BID_LINE_NUMBER", "OKE_CONTRACT_HEADER_ID", "OKE_CONTRACT_VERSION_ID", "RETROACTIVE_DATE", "SUPPLIER_REF_NUMBER", "CONTRACT_ID", "JOB_ID", "AMOUNT", "START_DATE", "CONTRACTOR_FIRST_NAME", "CONTRACTOR_LAST_NAME", "ORDER_TYPE_LOOKUP_CODE", "PURCHASE_BASIS", "MATCHING_BASIS", "SVC_AMOUNT_NOTIF_SENT", "SVC_COMPLETION_NOTIF_SENT", "BASE_UNIT_PRICE", "MANUAL_PRICE_CHANGE_FLAG", "RETAINAGE_RATE", "MAX_RETAINAGE_AMOUNT", "PROGRESS_PAYMENT_RATE", "RECOUPMENT_RATE", "CATALOG_NAME", "SUPPLIER_PART_AUXID", "IP_CATEGORY_ID", "LAST_UPDATED_PROGRAM", "GROUP_LINE_ID", "LINE_NUM_DISPLAY", "CLM_INFO_FLAG", "CLM_OPTION_INDICATOR", "CLM_BASE_LINE_NUM", "CLM_OPTION_NUM", "CLM_OPTION_FROM_DATE", "CLM_OPTION_TO_DATE", "CLM_FUNDED_FLAG", "CONTRACT_TYPE", "COST_CONSTRAINT", "CLM_IDC_TYPE", "USER_DOCUMENT_STATUS", "CLM_EXERCISED_FLAG", "CLM_EXERCISED_DATE", "CLM_FSC_PSC", "CLM_MAX_ORDER_AMOUNT", "CLM_MAX_ORDER_QUANTITY", "CLM_MAX_TOTAL_AMOUNT", "CLM_MAX_TOTAL_QUANTITY", "CLM_MDAPS_MAIS", "CLM_MIN_ORDER_AMOUNT", "CLM_MIN_ORDER_QUANTITY", "CLM_MIN_TOTAL_AMOUNT", "CLM_MIN_TOTAL_QUANTITY", "CLM_NAICS", "CLM_ORDER_END_DATE", "CLM_ORDER_START_DATE", "CLM_TOTAL_AMOUNT_ORDERED", "CLM_TOTAL_QUANTITY_ORDERED", "FROM_LINE_LOCATION_ID", "TAX_ATTRIBUTE_UPDATE_CODE", "UDA_TEMPLATE_ID", "CLM_DELIVERY_EVENT_CODE", "CLM_PAYMENT_INSTR_CODE", "CLM_UNDEF_FLAG", "CLM_UNDEF_ACTION_CODE", "CLM_APPROVED_UNDEF_AMOUNT", "CLM_UDA_PRICING_TOTAL", "CLM_POP_EXCEPTION_REASON", "CLM_EXHIBIT_NAME" FROM (SELECT MOD_DOC_PK1_VAL,MOD_DOC_PK2_VAL,MOD_DOC_PK3_VAL, ENTITY_NAME, column_name,mod_value from po_entity_differences where entity_name = 'LINE' AND MOD_DOC_SOURCE_NAME = 'PO_LINES_DRAFT_DIFF_V') pivot(Max(mod_value) FOR column_name IN ( 'LINE_TYPE_ID' LINE_TYPE_ID, 'LINE_NUM' LINE_NUM, 'ITEM_ID' ITEM_ID, 'ITEM_REVISION' ITEM_REVISION, 'CATEGORY_ID' CATEGORY_ID, 'ITEM_DESCRIPTION' ITEM_DESCRIPTION, 'UNIT_MEAS_LOOKUP_CODE' UNIT_MEAS_LOOKUP_CODE, 'QUANTITY_COMMITTED' QUANTITY_COMMITTED, 'COMMITTED_AMOUNT' COMMITTED_AMOUNT, 'ALLOW_PRICE_OVERRIDE_FLAG' ALLOW_PRICE_OVERRIDE_FLAG, 'NOT_TO_EXCEED_PRICE' NOT_TO_EXCEED_PRICE, 'LIST_PRICE_PER_UNIT' LIST_PRICE_PER_UNIT, 'UNIT_PRICE' UNIT_PRICE, 'QUANTITY' QUANTITY, 'UN_NUMBER_ID' UN_NUMBER_ID, 'HAZARD_CLASS_ID' HAZARD_CLASS_ID, 'NOTE_TO_VENDOR' NOTE_TO_VENDOR, 'FROM_HEADER_ID' FROM_HEADER_ID, 'FROM_LINE_ID' FROM_LINE_ID, 'MIN_ORDER_QUANTITY' MIN_ORDER_QUANTITY, 'MAX_ORDER_QUANTITY' MAX_ORDER_QUANTITY, 'QTY_RCV_TOLERANCE' QTY_RCV_TOLERANCE, 'OVER_TOLERANCE_ERROR_FLAG' OVER_TOLERANCE_ERROR_FLAG, 'MARKET_PRICE' MARKET_PRICE, 'UNORDERED_FLAG' UNORDERED_FLAG, 'CLOSED_FLAG' CLOSED_FLAG, 'USER_HOLD_FLAG' USER_HOLD_FLAG, 'CANCEL_FLAG' CANCEL_FLAG, 'CANCELLED_BY' CANCELLED_BY, 'CANCEL_DATE' CANCEL_DATE, 'CANCEL_REASON' CANCEL_REASON, 'FIRM_STATUS_LOOKUP_CODE' FIRM_STATUS_LOOKUP_CODE, 'FIRM_DATE' FIRM_DATE, 'VENDOR_PRODUCT_NUM' VENDOR_PRODUCT_NUM, 'CONTRACT_NUM' CONTRACT_NUM, 'TAXABLE_FLAG' TAXABLE_FLAG, 'TAX_NAME' TAX_NAME, 'TYPE_1099' TYPE_1099, 'CAPITAL_EXPENSE_FLAG' CAPITAL_EXPENSE_FLAG, 'NEGOTIATED_BY_PREPARER_FLAG' NEGOTIATED_BY_PREPARER_FLAG, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY, 'ATTRIBUTE1' ATTRIBUTE1, 'ATTRIBUTE2' ATTRIBUTE2, 'ATTRIBUTE3' ATTRIBUTE3, 'ATTRIBUTE4' ATTRIBUTE4, 'ATTRIBUTE5' ATTRIBUTE5, 'ATTRIBUTE6' ATTRIBUTE6, 'ATTRIBUTE7' ATTRIBUTE7, 'ATTRIBUTE8' ATTRIBUTE8, 'ATTRIBUTE9' ATTRIBUTE9, 'ATTRIBUTE10' ATTRIBUTE10, 'REFERENCE_NUM' REFERENCE_NUM, 'ATTRIBUTE11' ATTRIBUTE11, 'ATTRIBUTE12' ATTRIBUTE12, 'ATTRIBUTE13' ATTRIBUTE13, 'ATTRIBUTE14' ATTRIBUTE14, 'ATTRIBUTE15' ATTRIBUTE15, 'MIN_RELEASE_AMOUNT' MIN_RELEASE_AMOUNT, 'PRICE_TYPE_LOOKUP_CODE' PRICE_TYPE_LOOKUP_CODE, 'REVISION_NUM' REVISION_NUM, 'PRICE_BREAK_LOOKUP_CODE' PRICE_BREAK_LOOKUP_CODE, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG, 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT, 'REQUEST_ID' REQUEST_ID, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID, 'PROGRAM_ID' PROGRAM_ID, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE, 'CLOSED_CODE' CLOSED_CODE , 'CLOSED_BY' CLOSED_BY, 'CLOSED_DATE' CLOSED_DATE, 'CLOSED_REASON' CLOSED_REASON, 'TRANSACTION_REASON_CODE' TRANSACTION_REASON_CODE, 'ORG_ID' ORG_ID, 'GLOBAL_ATTRIBUTE_CATEGORY' GLOBAL_ATTRIBUTE_CATEGORY, 'GLOBAL_ATTRIBUTE1' GLOBAL_ATTRIBUTE1, 'GLOBAL_ATTRIBUTE2' GLOBAL_ATTRIBUTE2, 'GLOBAL_ATTRIBUTE3' GLOBAL_ATTRIBUTE3, 'GLOBAL_ATTRIBUTE4' GLOBAL_ATTRIBUTE4, 'GLOBAL_ATTRIBUTE5' GLOBAL_ATTRIBUTE5, 'GLOBAL_ATTRIBUTE6' GLOBAL_ATTRIBUTE6, 'GLOBAL_ATTRIBUTE7' GLOBAL_ATTRIBUTE7, 'GLOBAL_ATTRIBUTE8' GLOBAL_ATTRIBUTE8, 'GLOBAL_ATTRIBUTE9' GLOBAL_ATTRIBUTE9, 'GLOBAL_ATTRIBUTE10' GLOBAL_ATTRIBUTE10, 'GLOBAL_ATTRIBUTE11' GLOBAL_ATTRIBUTE11, 'GLOBAL_ATTRIBUTE12' GLOBAL_ATTRIBUTE12, 'GLOBAL_ATTRIBUTE13' GLOBAL_ATTRIBUTE13, 'GLOBAL_ATTRIBUTE14' GLOBAL_ATTRIBUTE14, 'GLOBAL_ATTRIBUTE15' GLOBAL_ATTRIBUTE15, 'GLOBAL_ATTRIBUTE16' GLOBAL_ATTRIBUTE16, 'GLOBAL_ATTRIBUTE17' GLOBAL_ATTRIBUTE17, 'GLOBAL_ATTRIBUTE18' GLOBAL_ATTRIBUTE18, 'GLOBAL_ATTRIBUTE19' GLOBAL_ATTRIBUTE19, 'GLOBAL_ATTRIBUTE20' GLOBAL_ATTRIBUTE20, 'EXPIRATION_DATE' EXPIRATION_DATE, 'QC_GRADE' QC_GRADE, 'BASE_UOM' BASE_UOM, 'BASE_QTY' BASE_QTY, 'SECONDARY_UOM' SECONDARY_UOM, 'SECONDARY_QTY' SECONDARY_QTY, 'LINE_REFERENCE_NUM' LINE_REFERENCE_NUM, 'PROJECT_ID' PROJECT_ID, 'TASK_ID' TASK_ID, 'TAX_CODE_ID' TAX_CODE_ID, 'SECONDARY_UNIT_OF_MEASURE' SECONDARY_UNIT_OF_MEASURE, 'SECONDARY_QUANTITY' SECONDARY_QUANTITY, 'PREFERRED_GRADE' PREFERRED_GRADE, 'AUCTION_HEADER_ID' AUCTION_HEADER_ID, 'AUCTION_DISPLAY_NUMBER' AUCTION_DISPLAY_NUMBER, 'AUCTION_LINE_NUMBER' AUCTION_LINE_NUMBER, 'BID_NUMBER' BID_NUMBER, 'BID_LINE_NUMBER' BID_LINE_NUMBER, 'OKE_CONTRACT_HEADER_ID' OKE_CONTRACT_HEADER_ID, 'OKE_CONTRACT_VERSION_ID' OKE_CONTRACT_VERSION_ID, 'RETROACTIVE_DATE' RETROACTIVE_DATE, 'SUPPLIER_REF_NUMBER' SUPPLIER_REF_NUMBER, 'CONTRACT_ID' CONTRACT_ID, 'JOB_ID' JOB_ID, 'AMOUNT' AMOUNT, 'START_DATE' START_DATE, 'CONTRACTOR_FIRST_NAME' CONTRACTOR_FIRST_NAME, 'CONTRACTOR_LAST_NAME' CONTRACTOR_LAST_NAME, 'ORDER_TYPE_LOOKUP_CODE' ORDER_TYPE_LOOKUP_CODE, 'PURCHASE_BASIS' PURCHASE_BASIS, 'MATCHING_BASIS' MATCHING_BASIS, 'SVC_AMOUNT_NOTIF_SENT' SVC_AMOUNT_NOTIF_SENT, 'SVC_COMPLETION_NOTIF_SENT' SVC_COMPLETION_NOTIF_SENT, 'BASE_UNIT_PRICE' BASE_UNIT_PRICE, 'MANUAL_PRICE_CHANGE_FLAG' MANUAL_PRICE_CHANGE_FLAG, 'RETAINAGE_RATE' RETAINAGE_RATE, 'MAX_RETAINAGE_AMOUNT' MAX_RETAINAGE_AMOUNT, 'PROGRESS_PAYMENT_RATE' PROGRESS_PAYMENT_RATE, 'RECOUPMENT_RATE' RECOUPMENT_RATE, 'CATALOG_NAME' CATALOG_NAME, 'SUPPLIER_PART_AUXID' SUPPLIER_PART_AUXID, 'IP_CATEGORY_ID' IP_CATEGORY_ID, 'LAST_UPDATED_PROGRAM' LAST_UPDATED_PROGRAM, 'GROUP_LINE_ID' GROUP_LINE_ID, 'LINE_NUM_DISPLAY' LINE_NUM_DISPLAY, 'CLM_INFO_FLAG' CLM_INFO_FLAG, 'CLM_OPTION_INDICATOR' CLM_OPTION_INDICATOR, 'CLM_BASE_LINE_NUM' CLM_BASE_LINE_NUM, 'CLM_OPTION_NUM' CLM_OPTION_NUM, 'CLM_OPTION_FROM_DATE' CLM_OPTION_FROM_DATE, 'CLM_OPTION_TO_DATE' CLM_OPTION_TO_DATE, 'CLM_FUNDED_FLAG' CLM_FUNDED_FLAG, 'CONTRACT_TYPE' CONTRACT_TYPE, 'COST_CONSTRAINT' COST_CONSTRAINT, 'CLM_IDC_TYPE' CLM_IDC_TYPE, 'USER_DOCUMENT_STATUS' USER_DOCUMENT_STATUS, 'CLM_EXERCISED_FLAG' CLM_EXERCISED_FLAG, 'CLM_EXERCISED_DATE' CLM_EXERCISED_DATE, 'CLM_FSC_PSC' CLM_FSC_PSC, 'CLM_MAX_ORDER_AMOUNT' CLM_MAX_ORDER_AMOUNT, 'CLM_MAX_ORDER_QUANTITY' CLM_MAX_ORDER_QUANTITY, 'CLM_MAX_TOTAL_AMOUNT' CLM_MAX_TOTAL_AMOUNT, 'CLM_MAX_TOTAL_QUANTITY' CLM_MAX_TOTAL_QUANTITY, 'CLM_MDAPS_MAIS' CLM_MDAPS_MAIS, 'CLM_MIN_ORDER_AMOUNT' CLM_MIN_ORDER_AMOUNT, 'CLM_MIN_ORDER_QUANTITY' CLM_MIN_ORDER_QUANTITY, 'CLM_MIN_TOTAL_AMOUNT' CLM_MIN_TOTAL_AMOUNT, 'CLM_MIN_TOTAL_QUANTITY' CLM_MIN_TOTAL_QUANTITY, 'CLM_NAICS' CLM_NAICS, 'CLM_ORDER_END_DATE' CLM_ORDER_END_DATE, 'CLM_ORDER_START_DATE' CLM_ORDER_START_DATE, 'CLM_TOTAL_AMOUNT_ORDERED' CLM_TOTAL_AMOUNT_ORDERED, 'CLM_TOTAL_QUANTITY_ORDERED' CLM_TOTAL_QUANTITY_ORDERED, 'FROM_LINE_LOCATION_ID' FROM_LINE_LOCATION_ID, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID, 'CLM_DELIVERY_EVENT_CODE' CLM_DELIVERY_EVENT_CODE, 'CLM_PAYMENT_INSTR_CODE' CLM_PAYMENT_INSTR_CODE, 'CLM_UNDEF_FLAG' CLM_UNDEF_FLAG, 'CLM_UNDEF_ACTION_CODE' CLM_UNDEF_ACTION_CODE, 'CLM_APPROVED_UNDEF_AMOUNT' CLM_APPROVED_UNDEF_AMOUNT, 'CLM_UDA_PRICING_TOTAL' CLM_UDA_PRICING_TOTAL, 'CLM_POP_EXCEPTION_REASON' CLM_POP_EXCEPTION_REASON, 'CLM_EXHIBIT_NAME' CLM_EXHIBIT_NAME))

View Text - HTML Formatted

SELECT "MOD_DOC_PK1_VAL"
, "MOD_DOC_PK2_VAL"
, "MOD_DOC_PK3_VAL"
, "ENTITY_NAME"
, "LINE_TYPE_ID"
, "LINE_NUM"
, "ITEM_ID"
, "ITEM_REVISION"
, "CATEGORY_ID"
, "ITEM_DESCRIPTION"
, "UNIT_MEAS_LOOKUP_CODE"
, "QUANTITY_COMMITTED"
, "COMMITTED_AMOUNT"
, "ALLOW_PRICE_OVERRIDE_FLAG"
, "NOT_TO_EXCEED_PRICE"
, "LIST_PRICE_PER_UNIT"
, "UNIT_PRICE"
, "QUANTITY"
, "UN_NUMBER_ID"
, "HAZARD_CLASS_ID"
, "NOTE_TO_VENDOR"
, "FROM_HEADER_ID"
, "FROM_LINE_ID"
, "MIN_ORDER_QUANTITY"
, "MAX_ORDER_QUANTITY"
, "QTY_RCV_TOLERANCE"
, "OVER_TOLERANCE_ERROR_FLAG"
, "MARKET_PRICE"
, "UNORDERED_FLAG"
, "CLOSED_FLAG"
, "USER_HOLD_FLAG"
, "CANCEL_FLAG"
, "CANCELLED_BY"
, "CANCEL_DATE"
, "CANCEL_REASON"
, "FIRM_STATUS_LOOKUP_CODE"
, "FIRM_DATE"
, "VENDOR_PRODUCT_NUM"
, "CONTRACT_NUM"
, "TAXABLE_FLAG"
, "TAX_NAME"
, "TYPE_1099"
, "CAPITAL_EXPENSE_FLAG"
, "NEGOTIATED_BY_PREPARER_FLAG"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "REFERENCE_NUM"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "MIN_RELEASE_AMOUNT"
, "PRICE_TYPE_LOOKUP_CODE"
, "REVISION_NUM"
, "PRICE_BREAK_LOOKUP_CODE"
, "LATEST_EXTERNAL_FLAG"
, "USSGL_TRANSACTION_CODE"
, "GOVERNMENT_CONTEXT"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "CLOSED_CODE"
, "CLOSED_BY"
, "CLOSED_DATE"
, "CLOSED_REASON"
, "TRANSACTION_REASON_CODE"
, "ORG_ID"
, "GLOBAL_ATTRIBUTE_CATEGORY"
, "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"
, "EXPIRATION_DATE"
, "QC_GRADE"
, "BASE_UOM"
, "BASE_QTY"
, "SECONDARY_UOM"
, "SECONDARY_QTY"
, "LINE_REFERENCE_NUM"
, "PROJECT_ID"
, "TASK_ID"
, "TAX_CODE_ID"
, "SECONDARY_UNIT_OF_MEASURE"
, "SECONDARY_QUANTITY"
, "PREFERRED_GRADE"
, "AUCTION_HEADER_ID"
, "AUCTION_DISPLAY_NUMBER"
, "AUCTION_LINE_NUMBER"
, "BID_NUMBER"
, "BID_LINE_NUMBER"
, "OKE_CONTRACT_HEADER_ID"
, "OKE_CONTRACT_VERSION_ID"
, "RETROACTIVE_DATE"
, "SUPPLIER_REF_NUMBER"
, "CONTRACT_ID"
, "JOB_ID"
, "AMOUNT"
, "START_DATE"
, "CONTRACTOR_FIRST_NAME"
, "CONTRACTOR_LAST_NAME"
, "ORDER_TYPE_LOOKUP_CODE"
, "PURCHASE_BASIS"
, "MATCHING_BASIS"
, "SVC_AMOUNT_NOTIF_SENT"
, "SVC_COMPLETION_NOTIF_SENT"
, "BASE_UNIT_PRICE"
, "MANUAL_PRICE_CHANGE_FLAG"
, "RETAINAGE_RATE"
, "MAX_RETAINAGE_AMOUNT"
, "PROGRESS_PAYMENT_RATE"
, "RECOUPMENT_RATE"
, "CATALOG_NAME"
, "SUPPLIER_PART_AUXID"
, "IP_CATEGORY_ID"
, "LAST_UPDATED_PROGRAM"
, "GROUP_LINE_ID"
, "LINE_NUM_DISPLAY"
, "CLM_INFO_FLAG"
, "CLM_OPTION_INDICATOR"
, "CLM_BASE_LINE_NUM"
, "CLM_OPTION_NUM"
, "CLM_OPTION_FROM_DATE"
, "CLM_OPTION_TO_DATE"
, "CLM_FUNDED_FLAG"
, "CONTRACT_TYPE"
, "COST_CONSTRAINT"
, "CLM_IDC_TYPE"
, "USER_DOCUMENT_STATUS"
, "CLM_EXERCISED_FLAG"
, "CLM_EXERCISED_DATE"
, "CLM_FSC_PSC"
, "CLM_MAX_ORDER_AMOUNT"
, "CLM_MAX_ORDER_QUANTITY"
, "CLM_MAX_TOTAL_AMOUNT"
, "CLM_MAX_TOTAL_QUANTITY"
, "CLM_MDAPS_MAIS"
, "CLM_MIN_ORDER_AMOUNT"
, "CLM_MIN_ORDER_QUANTITY"
, "CLM_MIN_TOTAL_AMOUNT"
, "CLM_MIN_TOTAL_QUANTITY"
, "CLM_NAICS"
, "CLM_ORDER_END_DATE"
, "CLM_ORDER_START_DATE"
, "CLM_TOTAL_AMOUNT_ORDERED"
, "CLM_TOTAL_QUANTITY_ORDERED"
, "FROM_LINE_LOCATION_ID"
, "TAX_ATTRIBUTE_UPDATE_CODE"
, "UDA_TEMPLATE_ID"
, "CLM_DELIVERY_EVENT_CODE"
, "CLM_PAYMENT_INSTR_CODE"
, "CLM_UNDEF_FLAG"
, "CLM_UNDEF_ACTION_CODE"
, "CLM_APPROVED_UNDEF_AMOUNT"
, "CLM_UDA_PRICING_TOTAL"
, "CLM_POP_EXCEPTION_REASON"
, "CLM_EXHIBIT_NAME"
FROM (SELECT MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL
, MOD_DOC_PK3_VAL
, ENTITY_NAME
, COLUMN_NAME
, MOD_VALUE
FROM PO_ENTITY_DIFFERENCES
WHERE ENTITY_NAME = 'LINE'
AND MOD_DOC_SOURCE_NAME = 'PO_LINES_DRAFT_DIFF_V') PIVOT(MAX(MOD_VALUE) FOR COLUMN_NAME IN ( 'LINE_TYPE_ID' LINE_TYPE_ID
, 'LINE_NUM' LINE_NUM
, 'ITEM_ID' ITEM_ID
, 'ITEM_REVISION' ITEM_REVISION
, 'CATEGORY_ID' CATEGORY_ID
, 'ITEM_DESCRIPTION' ITEM_DESCRIPTION
, 'UNIT_MEAS_LOOKUP_CODE' UNIT_MEAS_LOOKUP_CODE
, 'QUANTITY_COMMITTED' QUANTITY_COMMITTED
, 'COMMITTED_AMOUNT' COMMITTED_AMOUNT
, 'ALLOW_PRICE_OVERRIDE_FLAG' ALLOW_PRICE_OVERRIDE_FLAG
, 'NOT_TO_EXCEED_PRICE' NOT_TO_EXCEED_PRICE
, 'LIST_PRICE_PER_UNIT' LIST_PRICE_PER_UNIT
, 'UNIT_PRICE' UNIT_PRICE
, 'QUANTITY' QUANTITY
, 'UN_NUMBER_ID' UN_NUMBER_ID
, 'HAZARD_CLASS_ID' HAZARD_CLASS_ID
, 'NOTE_TO_VENDOR' NOTE_TO_VENDOR
, 'FROM_HEADER_ID' FROM_HEADER_ID
, 'FROM_LINE_ID' FROM_LINE_ID
, 'MIN_ORDER_QUANTITY' MIN_ORDER_QUANTITY
, 'MAX_ORDER_QUANTITY' MAX_ORDER_QUANTITY
, 'QTY_RCV_TOLERANCE' QTY_RCV_TOLERANCE
, 'OVER_TOLERANCE_ERROR_FLAG' OVER_TOLERANCE_ERROR_FLAG
, 'MARKET_PRICE' MARKET_PRICE
, 'UNORDERED_FLAG' UNORDERED_FLAG
, 'CLOSED_FLAG' CLOSED_FLAG
, 'USER_HOLD_FLAG' USER_HOLD_FLAG
, 'CANCEL_FLAG' CANCEL_FLAG
, 'CANCELLED_BY' CANCELLED_BY
, 'CANCEL_DATE' CANCEL_DATE
, 'CANCEL_REASON' CANCEL_REASON
, 'FIRM_STATUS_LOOKUP_CODE' FIRM_STATUS_LOOKUP_CODE
, 'FIRM_DATE' FIRM_DATE
, 'VENDOR_PRODUCT_NUM' VENDOR_PRODUCT_NUM
, 'CONTRACT_NUM' CONTRACT_NUM
, 'TAXABLE_FLAG' TAXABLE_FLAG
, 'TAX_NAME' TAX_NAME
, 'TYPE_1099' TYPE_1099
, 'CAPITAL_EXPENSE_FLAG' CAPITAL_EXPENSE_FLAG
, 'NEGOTIATED_BY_PREPARER_FLAG' NEGOTIATED_BY_PREPARER_FLAG
, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY
, 'ATTRIBUTE1' ATTRIBUTE1
, 'ATTRIBUTE2' ATTRIBUTE2
, 'ATTRIBUTE3' ATTRIBUTE3
, 'ATTRIBUTE4' ATTRIBUTE4
, 'ATTRIBUTE5' ATTRIBUTE5
, 'ATTRIBUTE6' ATTRIBUTE6
, 'ATTRIBUTE7' ATTRIBUTE7
, 'ATTRIBUTE8' ATTRIBUTE8
, 'ATTRIBUTE9' ATTRIBUTE9
, 'ATTRIBUTE10' ATTRIBUTE10
, 'REFERENCE_NUM' REFERENCE_NUM
, 'ATTRIBUTE11' ATTRIBUTE11
, 'ATTRIBUTE12' ATTRIBUTE12
, 'ATTRIBUTE13' ATTRIBUTE13
, 'ATTRIBUTE14' ATTRIBUTE14
, 'ATTRIBUTE15' ATTRIBUTE15
, 'MIN_RELEASE_AMOUNT' MIN_RELEASE_AMOUNT
, 'PRICE_TYPE_LOOKUP_CODE' PRICE_TYPE_LOOKUP_CODE
, 'REVISION_NUM' REVISION_NUM
, 'PRICE_BREAK_LOOKUP_CODE' PRICE_BREAK_LOOKUP_CODE
, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG
, 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE
, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT
, 'REQUEST_ID' REQUEST_ID
, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID
, 'PROGRAM_ID' PROGRAM_ID
, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE
, 'CLOSED_CODE' CLOSED_CODE
, 'CLOSED_BY' CLOSED_BY
, 'CLOSED_DATE' CLOSED_DATE
, 'CLOSED_REASON' CLOSED_REASON
, 'TRANSACTION_REASON_CODE' TRANSACTION_REASON_CODE
, 'ORG_ID' ORG_ID
, 'GLOBAL_ATTRIBUTE_CATEGORY' GLOBAL_ATTRIBUTE_CATEGORY
, 'GLOBAL_ATTRIBUTE1' GLOBAL_ATTRIBUTE1
, 'GLOBAL_ATTRIBUTE2' GLOBAL_ATTRIBUTE2
, 'GLOBAL_ATTRIBUTE3' GLOBAL_ATTRIBUTE3
, 'GLOBAL_ATTRIBUTE4' GLOBAL_ATTRIBUTE4
, 'GLOBAL_ATTRIBUTE5' GLOBAL_ATTRIBUTE5
, 'GLOBAL_ATTRIBUTE6' GLOBAL_ATTRIBUTE6
, 'GLOBAL_ATTRIBUTE7' GLOBAL_ATTRIBUTE7
, 'GLOBAL_ATTRIBUTE8' GLOBAL_ATTRIBUTE8
, 'GLOBAL_ATTRIBUTE9' GLOBAL_ATTRIBUTE9
, 'GLOBAL_ATTRIBUTE10' GLOBAL_ATTRIBUTE10
, 'GLOBAL_ATTRIBUTE11' GLOBAL_ATTRIBUTE11
, 'GLOBAL_ATTRIBUTE12' GLOBAL_ATTRIBUTE12
, 'GLOBAL_ATTRIBUTE13' GLOBAL_ATTRIBUTE13
, 'GLOBAL_ATTRIBUTE14' GLOBAL_ATTRIBUTE14
, 'GLOBAL_ATTRIBUTE15' GLOBAL_ATTRIBUTE15
, 'GLOBAL_ATTRIBUTE16' GLOBAL_ATTRIBUTE16
, 'GLOBAL_ATTRIBUTE17' GLOBAL_ATTRIBUTE17
, 'GLOBAL_ATTRIBUTE18' GLOBAL_ATTRIBUTE18
, 'GLOBAL_ATTRIBUTE19' GLOBAL_ATTRIBUTE19
, 'GLOBAL_ATTRIBUTE20' GLOBAL_ATTRIBUTE20
, 'EXPIRATION_DATE' EXPIRATION_DATE
, 'QC_GRADE' QC_GRADE
, 'BASE_UOM' BASE_UOM
, 'BASE_QTY' BASE_QTY
, 'SECONDARY_UOM' SECONDARY_UOM
, 'SECONDARY_QTY' SECONDARY_QTY
, 'LINE_REFERENCE_NUM' LINE_REFERENCE_NUM
, 'PROJECT_ID' PROJECT_ID
, 'TASK_ID' TASK_ID
, 'TAX_CODE_ID' TAX_CODE_ID
, 'SECONDARY_UNIT_OF_MEASURE' SECONDARY_UNIT_OF_MEASURE
, 'SECONDARY_QUANTITY' SECONDARY_QUANTITY
, 'PREFERRED_GRADE' PREFERRED_GRADE
, 'AUCTION_HEADER_ID' AUCTION_HEADER_ID
, 'AUCTION_DISPLAY_NUMBER' AUCTION_DISPLAY_NUMBER
, 'AUCTION_LINE_NUMBER' AUCTION_LINE_NUMBER
, 'BID_NUMBER' BID_NUMBER
, 'BID_LINE_NUMBER' BID_LINE_NUMBER
, 'OKE_CONTRACT_HEADER_ID' OKE_CONTRACT_HEADER_ID
, 'OKE_CONTRACT_VERSION_ID' OKE_CONTRACT_VERSION_ID
, 'RETROACTIVE_DATE' RETROACTIVE_DATE
, 'SUPPLIER_REF_NUMBER' SUPPLIER_REF_NUMBER
, 'CONTRACT_ID' CONTRACT_ID
, 'JOB_ID' JOB_ID
, 'AMOUNT' AMOUNT
, 'START_DATE' START_DATE
, 'CONTRACTOR_FIRST_NAME' CONTRACTOR_FIRST_NAME
, 'CONTRACTOR_LAST_NAME' CONTRACTOR_LAST_NAME
, 'ORDER_TYPE_LOOKUP_CODE' ORDER_TYPE_LOOKUP_CODE
, 'PURCHASE_BASIS' PURCHASE_BASIS
, 'MATCHING_BASIS' MATCHING_BASIS
, 'SVC_AMOUNT_NOTIF_SENT' SVC_AMOUNT_NOTIF_SENT
, 'SVC_COMPLETION_NOTIF_SENT' SVC_COMPLETION_NOTIF_SENT
, 'BASE_UNIT_PRICE' BASE_UNIT_PRICE
, 'MANUAL_PRICE_CHANGE_FLAG' MANUAL_PRICE_CHANGE_FLAG
, 'RETAINAGE_RATE' RETAINAGE_RATE
, 'MAX_RETAINAGE_AMOUNT' MAX_RETAINAGE_AMOUNT
, 'PROGRESS_PAYMENT_RATE' PROGRESS_PAYMENT_RATE
, 'RECOUPMENT_RATE' RECOUPMENT_RATE
, 'CATALOG_NAME' CATALOG_NAME
, 'SUPPLIER_PART_AUXID' SUPPLIER_PART_AUXID
, 'IP_CATEGORY_ID' IP_CATEGORY_ID
, 'LAST_UPDATED_PROGRAM' LAST_UPDATED_PROGRAM
, 'GROUP_LINE_ID' GROUP_LINE_ID
, 'LINE_NUM_DISPLAY' LINE_NUM_DISPLAY
, 'CLM_INFO_FLAG' CLM_INFO_FLAG
, 'CLM_OPTION_INDICATOR' CLM_OPTION_INDICATOR
, 'CLM_BASE_LINE_NUM' CLM_BASE_LINE_NUM
, 'CLM_OPTION_NUM' CLM_OPTION_NUM
, 'CLM_OPTION_FROM_DATE' CLM_OPTION_FROM_DATE
, 'CLM_OPTION_TO_DATE' CLM_OPTION_TO_DATE
, 'CLM_FUNDED_FLAG' CLM_FUNDED_FLAG
, 'CONTRACT_TYPE' CONTRACT_TYPE
, 'COST_CONSTRAINT' COST_CONSTRAINT
, 'CLM_IDC_TYPE' CLM_IDC_TYPE
, 'USER_DOCUMENT_STATUS' USER_DOCUMENT_STATUS
, 'CLM_EXERCISED_FLAG' CLM_EXERCISED_FLAG
, 'CLM_EXERCISED_DATE' CLM_EXERCISED_DATE
, 'CLM_FSC_PSC' CLM_FSC_PSC
, 'CLM_MAX_ORDER_AMOUNT' CLM_MAX_ORDER_AMOUNT
, 'CLM_MAX_ORDER_QUANTITY' CLM_MAX_ORDER_QUANTITY
, 'CLM_MAX_TOTAL_AMOUNT' CLM_MAX_TOTAL_AMOUNT
, 'CLM_MAX_TOTAL_QUANTITY' CLM_MAX_TOTAL_QUANTITY
, 'CLM_MDAPS_MAIS' CLM_MDAPS_MAIS
, 'CLM_MIN_ORDER_AMOUNT' CLM_MIN_ORDER_AMOUNT
, 'CLM_MIN_ORDER_QUANTITY' CLM_MIN_ORDER_QUANTITY
, 'CLM_MIN_TOTAL_AMOUNT' CLM_MIN_TOTAL_AMOUNT
, 'CLM_MIN_TOTAL_QUANTITY' CLM_MIN_TOTAL_QUANTITY
, 'CLM_NAICS' CLM_NAICS
, 'CLM_ORDER_END_DATE' CLM_ORDER_END_DATE
, 'CLM_ORDER_START_DATE' CLM_ORDER_START_DATE
, 'CLM_TOTAL_AMOUNT_ORDERED' CLM_TOTAL_AMOUNT_ORDERED
, 'CLM_TOTAL_QUANTITY_ORDERED' CLM_TOTAL_QUANTITY_ORDERED
, 'FROM_LINE_LOCATION_ID' FROM_LINE_LOCATION_ID
, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE
, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID
, 'CLM_DELIVERY_EVENT_CODE' CLM_DELIVERY_EVENT_CODE
, 'CLM_PAYMENT_INSTR_CODE' CLM_PAYMENT_INSTR_CODE
, 'CLM_UNDEF_FLAG' CLM_UNDEF_FLAG
, 'CLM_UNDEF_ACTION_CODE' CLM_UNDEF_ACTION_CODE
, 'CLM_APPROVED_UNDEF_AMOUNT' CLM_APPROVED_UNDEF_AMOUNT
, 'CLM_UDA_PRICING_TOTAL' CLM_UDA_PRICING_TOTAL
, 'CLM_POP_EXCEPTION_REASON' CLM_POP_EXCEPTION_REASON
, 'CLM_EXHIBIT_NAME' CLM_EXHIBIT_NAME))