VIEW: PON.PON_ITEM_PRICES_INTERFACE#

Source

View Text - Preformatted

select BATCH_ID#1 BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, INTERFACE_TYPE INTERFACE_TYPE, AUCTION_HEADER_ID#1 AUCTION_HEADER_ID, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, UNIT_OF_MEASURE UNIT_OF_MEASURE, CURRENCY_CODE CURRENCY_CODE, QUANTITY QUANTITY, UOM_CODE UOM_CODE, PRICE PRICE, PROMISED_DATE PROMISED_DATE, NEED_BY_DATE NEED_BY_DATE, TARGET_PRICE TARGET_PRICE, THRESHOLD_PRICE THRESHOLD_PRICE, BID_START_PRICE BID_START_PRICE, NOTE_TO_BIDDERS NOTE_TO_BIDDERS, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, CURRENT_PRICE CURRENT_PRICE, RESERVE_PRICE RESERVE_PRICE, DISPLAY_TARGET_FLAG DISPLAY_TARGET_FLAG, INTERFACE_ITEM_TYPE INTERFACE_ITEM_TYPE, INTERFACE_LOT_LINE_ID INTERFACE_LOT_LINE_ID, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, PO_RCPT_TOLERANCE_PCT PO_RCPT_TOLERANCE_PCT, NUM_DAYS_EARLY NUM_DAYS_EARLY, NUM_DAYS_LATE NUM_DAYS_LATE, SHIP_TO_LOCATION SHIP_TO_LOCATION, DISPLAY_TARGET_PRICE_FLAG DISPLAY_TARGET_PRICE_FLAG, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE, PROXY_BID_LIMIT_PRICE PROXY_BID_LIMIT_PRICE, BID_CURRENCY_PRICE BID_CURRENCY_PRICE, ATTACHMENT_URL ATTACHMENT_URL, ATTACHMENT_DESC ATTACHMENT_DESC, ACTION ACTION, NEED_BY_START_DATE NEED_BY_START_DATE, LINE_TYPE LINE_TYPE, LINE_TYPE_ID LINE_TYPE_ID, LINE_ORIGINATION_CODE LINE_ORIGINATION_CODE, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, ITEM_NUMBER ITEM_NUMBER, ITEM_REVISION ITEM_REVISION, ITEM_ID ITEM_ID, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG, PRICE_AND_QUANTITY_APPLY PRICE_AND_QUANTITY_APPLY, DISP_LINE_NUMBER DISP_LINE_NUMBER, ADDITIONAL_JOB_DETAILS ADDITIONAL_JOB_DETAILS, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE, PURCHASE_BASIS PURCHASE_BASIS, JOB_ID JOB_ID, UNIT_TARGET_PRICE UNIT_TARGET_PRICE, UNIT_DISPLAY_TARGET_FLAG UNIT_DISPLAY_TARGET_FLAG, GROUP_TYPE GROUP_TYPE, PARENT_LINE_NUMBER PARENT_LINE_NUMBER, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER, ADVANCE_AMOUNT ADVANCE_AMOUNT, RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT, PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT, RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, WORK_APPROVER_USER_NAME WORK_APPROVER_USER_NAME, WORK_APPROVER_USER_ID WORK_APPROVER_USER_ID, PROJECT_NUMBER PROJECT_NUMBER, PROJECT_ID PROJECT_ID, PROJECT_TASK_NUMBER PROJECT_TASK_NUMBER, PROJECT_TASK_ID PROJECT_TASK_ID, PROJECT_AWARD_NUMBER PROJECT_AWARD_NUMBER, PROJECT_AWARD_ID PROJECT_AWARD_ID, PROJECT_EXPENDITURE_TYPE PROJECT_EXPENDITURE_TYPE, PROJECT_EXP_ORGANIZATION_NAME PROJECT_EXP_ORGANIZATION_NAME, PROJECT_EXP_ORGANIZATION_ID PROJECT_EXP_ORGANIZATION_ID, PROJECT_EXPENDITURE_ITEM_DATE PROJECT_EXPENDITURE_ITEM_DATE, IP_CATEGORY_NAME IP_CATEGORY_NAME, IP_CATEGORY_ID IP_CATEGORY_ID, OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG, SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER, LINE_NUM_DISPLAY LINE_NUM_DISPLAY, GROUP_LINE_ID GROUP_LINE_ID, 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, CLM_NEED_BY_DATE CLM_NEED_BY_DATE, CLM_IDC_TYPE CLM_IDC_TYPE, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, CLM_AMOUNT CLM_AMOUNT, CLM_UNIT_PRICE CLM_UNIT_PRICE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, PRICE_BREAK_TYPE PRICE_BREAK_TYPE, PRICE_BREAK_NEG_FLAG PRICE_BREAK_NEG_FLAG, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE, CLM_DELIVERY_EVENT CLM_DELIVERY_EVENT, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM, CLM_DELIVERY_PERIOD_UOM_CODE CLM_DELIVERY_PERIOD_UOM_CODE, CLM_POP_DURATION CLM_POP_DURATION, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM, CLM_POP_DURATION_UOM_CODE CLM_POP_DURATION_UOM_CODE from "PON"."PON_ITEM_PRICES_INTERFACE"

View Text - HTML Formatted

SELECT BATCH_ID#1 BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, INTERFACE_TYPE INTERFACE_TYPE
, AUCTION_HEADER_ID#1 AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, CURRENCY_CODE CURRENCY_CODE
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, PRICE PRICE
, PROMISED_DATE PROMISED_DATE
, NEED_BY_DATE NEED_BY_DATE
, TARGET_PRICE TARGET_PRICE
, THRESHOLD_PRICE THRESHOLD_PRICE
, BID_START_PRICE BID_START_PRICE
, NOTE_TO_BIDDERS NOTE_TO_BIDDERS
, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, CURRENT_PRICE CURRENT_PRICE
, RESERVE_PRICE RESERVE_PRICE
, DISPLAY_TARGET_FLAG DISPLAY_TARGET_FLAG
, INTERFACE_ITEM_TYPE INTERFACE_ITEM_TYPE
, INTERFACE_LOT_LINE_ID INTERFACE_LOT_LINE_ID
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, PO_RCPT_TOLERANCE_PCT PO_RCPT_TOLERANCE_PCT
, NUM_DAYS_EARLY NUM_DAYS_EARLY
, NUM_DAYS_LATE NUM_DAYS_LATE
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, DISPLAY_TARGET_PRICE_FLAG DISPLAY_TARGET_PRICE_FLAG
, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE
, PROXY_BID_LIMIT_PRICE PROXY_BID_LIMIT_PRICE
, BID_CURRENCY_PRICE BID_CURRENCY_PRICE
, ATTACHMENT_URL ATTACHMENT_URL
, ATTACHMENT_DESC ATTACHMENT_DESC
, ACTION ACTION
, NEED_BY_START_DATE NEED_BY_START_DATE
, LINE_TYPE LINE_TYPE
, LINE_TYPE_ID LINE_TYPE_ID
, LINE_ORIGINATION_CODE LINE_ORIGINATION_CODE
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, ITEM_NUMBER ITEM_NUMBER
, ITEM_REVISION ITEM_REVISION
, ITEM_ID ITEM_ID
, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG
, PRICE_AND_QUANTITY_APPLY PRICE_AND_QUANTITY_APPLY
, DISP_LINE_NUMBER DISP_LINE_NUMBER
, ADDITIONAL_JOB_DETAILS ADDITIONAL_JOB_DETAILS
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE
, PURCHASE_BASIS PURCHASE_BASIS
, JOB_ID JOB_ID
, UNIT_TARGET_PRICE UNIT_TARGET_PRICE
, UNIT_DISPLAY_TARGET_FLAG UNIT_DISPLAY_TARGET_FLAG
, GROUP_TYPE GROUP_TYPE
, PARENT_LINE_NUMBER PARENT_LINE_NUMBER
, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER
, ADVANCE_AMOUNT ADVANCE_AMOUNT
, RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT
, PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT
, RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT
, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT
, WORK_APPROVER_USER_NAME WORK_APPROVER_USER_NAME
, WORK_APPROVER_USER_ID WORK_APPROVER_USER_ID
, PROJECT_NUMBER PROJECT_NUMBER
, PROJECT_ID PROJECT_ID
, PROJECT_TASK_NUMBER PROJECT_TASK_NUMBER
, PROJECT_TASK_ID PROJECT_TASK_ID
, PROJECT_AWARD_NUMBER PROJECT_AWARD_NUMBER
, PROJECT_AWARD_ID PROJECT_AWARD_ID
, PROJECT_EXPENDITURE_TYPE PROJECT_EXPENDITURE_TYPE
, PROJECT_EXP_ORGANIZATION_NAME PROJECT_EXP_ORGANIZATION_NAME
, PROJECT_EXP_ORGANIZATION_ID PROJECT_EXP_ORGANIZATION_ID
, PROJECT_EXPENDITURE_ITEM_DATE PROJECT_EXPENDITURE_ITEM_DATE
, IP_CATEGORY_NAME IP_CATEGORY_NAME
, IP_CATEGORY_ID IP_CATEGORY_ID
, OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG
, SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
, GROUP_LINE_ID GROUP_LINE_ID
, 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
, CLM_NEED_BY_DATE CLM_NEED_BY_DATE
, CLM_IDC_TYPE CLM_IDC_TYPE
, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT
, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, CLM_AMOUNT CLM_AMOUNT
, CLM_UNIT_PRICE CLM_UNIT_PRICE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, PRICE_BREAK_TYPE PRICE_BREAK_TYPE
, PRICE_BREAK_NEG_FLAG PRICE_BREAK_NEG_FLAG
, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE
, CLM_DELIVERY_EVENT CLM_DELIVERY_EVENT
, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM
, CLM_DELIVERY_PERIOD_UOM_CODE CLM_DELIVERY_PERIOD_UOM_CODE
, CLM_POP_DURATION CLM_POP_DURATION
, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM
, CLM_POP_DURATION_UOM_CODE CLM_POP_DURATION_UOM_CODE
FROM "PON"."PON_ITEM_PRICES_INTERFACE"