PON_BID_SHIPMENTS_MSV

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name

BID_NUMBER LINE_NUMBER SHIPMENT_NUMBER AUCTION_HEADER_ID AUCTION_SHIPMENT_NUMBER SHIPMENT_TYPE SHIP_TO_ORGANIZATION_ID SHIP_TO_LOCATION_ID QUANTITY PRICE_TYPE PRICE BID_CURRENCY_PRICE PRICE_DISCOUNT EFFECTIVE_START_DATE EFFECTIVE_END_DATE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN HAS_PRICE_DIFFERENTIALS_FLAG UNIT_PRICE BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_PRICE OLD_PRICE_DISCOUNT OLD_SHIP_TO_ORG_ID OLD_SHIP_TO_LOC_ID OLD_EFFECTIVE_START_DATE OLD_EFFECTIVE_END_DATE OLD_QUANTITY OLD_PRICE_TYPE MAX_QUANTITY PER_UNIT_PRICE_COMPONENT OBJECT_VERSION_NUMBER INTERFACE_LINE_ID OLD_MAX_QUANTITY AUCTION_LINE_NUMBER

Query

SQL_Statement

SELECT pbs.BID_NUMBER BID_NUMBER, pbs.LINE_NUMBER LINE_NUMBER, pbs.SHIPMENT_NUMBER SHIPMENT_NUMBER, pbs.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbs.AUCTION_SHIPMENT_NUMBER AUCTION_SHIPMENT_NUMBER, pbs.SHIPMENT_TYPE SHIPMENT_TYPE, pbs.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, pbs.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, pbs.QUANTITY QUANTITY, pbs.PRICE_TYPE PRICE_TYPE, pbs.PRICE PRICE, pbs.BID_CURRENCY_PRICE BID_CURRENCY_PRICE, pbs.PRICE_DISCOUNT PRICE_DISCOUNT, pbs.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pbs.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pbs.CREATION_DATE CREATION_DATE, pbs.CREATED_BY CREATED_BY, pbs.LAST_UPDATE_DATE LAST_UPDATE_DATE, pbs.LAST_UPDATED_BY LAST_UPDATED_BY, pbs.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbs.HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, pbs.UNIT_PRICE UNIT_PRICE, pbs.BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE, pbs.OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_UNIT_PRICE, pbs.OLD_BID_CURRENCY_PRICE OLD_BID_CURRENCY_PRICE, pbs.OLD_PRICE_DISCOUNT OLD_PRICE_DISCOUNT, pbs.OLD_SHIP_TO_ORG_ID OLD_SHIP_TO_ORG_ID, pbs.OLD_SHIP_TO_LOC_ID OLD_SHIP_TO_LOC_ID, pbs.OLD_EFFECTIVE_START_DATE OLD_EFFECTIVE_START_DATE, pbs.OLD_EFFECTIVE_END_DATE OLD_EFFECTIVE_END_DATE, pbs.OLD_QUANTITY OLD_QUANTITY, pbs.OLD_PRICE_TYPE OLD_PRICE_TYPE, pbs.MAX_QUANTITY MAX_QUANTITY, pbs.PER_UNIT_PRICE_COMPONENT PER_UNIT_PRICE_COMPONENT, pbs.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbs.INTERFACE_LINE_ID INTERFACE_LINE_ID, pbs.OLD_MAX_QUANTITY OLD_MAX_QUANTITY, pbs.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER FROM PON_BID_SHIPMENTS pbs, PON_AUCTION_HEADERS_ALL pah, PON_BID_HEADERS pbh WHERE pbs.BID_NUMBER = pbh.BID_NUMBER AND pah.AUCTION_HEADER_ID = pbh.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))