VIEW: APPS.POA_DBI_NEG_F_V

Source

View Text - Preformatted

SELECT fact.auction_header_id auction_header_id, fact.auction_line_number auction_line_number, fact.bid_number bid_number, fact.bid_line_number bid_line_number, fact.award_qty award_qty, fact.award_amount_b award_amount_b, fact.award_amount_g award_amount_g, fact.award_amount_sg award_amount_sg, fact.po_header_id po_header_id, fact.auction_creation_date auction_creation_date, fact.award_complete_date award_complete_date, fact.rfi_complete_date rfi_complete_date, fact.award_status award_status, fact.contract_type contract_type, fact.org_id org_id, com.commodity_id commodity_id, fact.category_id category_id, fact.supplier_id supplier_id, fact.supplier_site_id supplier_site_id, fact.po_item_id po_item_id, fact.base_uom base_uom, fact.negotiation_creator_id negotiation_creator_id, fact.doctype_id doctype_id from poa_dbi_neg_f fact, po_commodity_categories com WHERE fact.category_id = com.category_id

View Text - HTML Formatted

SELECT FACT.AUCTION_HEADER_ID AUCTION_HEADER_ID
, FACT.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, FACT.BID_NUMBER BID_NUMBER
, FACT.BID_LINE_NUMBER BID_LINE_NUMBER
, FACT.AWARD_QTY AWARD_QTY
, FACT.AWARD_AMOUNT_B AWARD_AMOUNT_B
, FACT.AWARD_AMOUNT_G AWARD_AMOUNT_G
, FACT.AWARD_AMOUNT_SG AWARD_AMOUNT_SG
, FACT.PO_HEADER_ID PO_HEADER_ID
, FACT.AUCTION_CREATION_DATE AUCTION_CREATION_DATE
, FACT.AWARD_COMPLETE_DATE AWARD_COMPLETE_DATE
, FACT.RFI_COMPLETE_DATE RFI_COMPLETE_DATE
, FACT.AWARD_STATUS AWARD_STATUS
, FACT.CONTRACT_TYPE CONTRACT_TYPE
, FACT.ORG_ID ORG_ID
, COM.COMMODITY_ID COMMODITY_ID
, FACT.CATEGORY_ID CATEGORY_ID
, FACT.SUPPLIER_ID SUPPLIER_ID
, FACT.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, FACT.PO_ITEM_ID PO_ITEM_ID
, FACT.BASE_UOM BASE_UOM
, FACT.NEGOTIATION_CREATOR_ID NEGOTIATION_CREATOR_ID
, FACT.DOCTYPE_ID DOCTYPE_ID
FROM POA_DBI_NEG_F FACT
, PO_COMMODITY_CATEGORIES COM
WHERE FACT.CATEGORY_ID = COM.CATEGORY_ID