[Home] [Help]
MATERIALIZED VIEW: APPS.POA_NEG_000_MV
Source
SELECT /* 12.0: bug#4526784 */
1 umarker,
cal.rowid crid,
com.rowid comrid,
f.rowid frid,
cal.ent_year_id,
cal.ent_qtr_id,
cal.ent_period_id,
cal.week_id,
cal.report_date_julian day_id,
f.auction_header_id,
f.auction_line_number,
f.bid_number,
f.bid_line_number,
f.po_header_id,
f.doctype_id,
f.auction_round_number,
f.auction_creation_date,
f.publish_date,
f.open_bidding_date,
f.close_bidding_date,
f.prev_round_close_date,
f.next_round_creation_date,
f.award_date,
decode(f.award_status,'NO',to_date(null), f.award_complete_date) award_complete_date,
decode(f.award_status,'NO',to_date(null), f.rfi_complete_date) rfi_complete_date,
f.org_id,
com.commodity_id,
f.negotiation_creator_id,
f.category_id,
f.po_item_id,
f.supplier_id,
f.supplier_site_id,
f.quantity,
f.award_qty,
f.award_price,
f.current_price,
f.award_amount_t,
f.award_amount_b,
f.award_amount_g,
f.award_amount_sg,
f.current_amount_t,
f.current_amount_b,
f.current_amount_g,
f.current_amount_sg,
f.auction_status,
f.award_status,
f.allocation_status,
f.supplier_invite_date,
f.base_uom,
f.contract_type
FROM
POA.POA_DBI_NEG_F f,
FII.FII_TIME_DAY cal,
PO.PO_COMMODITY_CATEGORIES com
WHERE
trunc(f.rfi_complete_date) = cal.report_date
and f.category_id = com.category_id
UNION ALL
SELECT /* 12.0: bug#4526784 */
2 umarker,
cal.rowid crid,
com.rowid comrid,
f.rowid frid,
cal.ent_year_id,
cal.ent_qtr_id,
cal.ent_period_id,
cal.week_id,
cal.report_date_julian day_id,
f.auction_header_id,
f.auction_line_number,
f.bid_number,
f.bid_line_number,
f.po_header_id,
f.doctype_id,
f.auction_round_number,
f.auction_creation_date,
f.publish_date,
f.open_bidding_date,
f.close_bidding_date,
f.prev_round_close_date,
f.next_round_creation_date,
f.award_date,
decode(f.award_status,'NO',to_date(null), f.award_complete_date) award_complete_date,
decode(f.award_status,'NO',to_date(null), f.rfi_complete_date) rfi_complete_date,
f.org_id,
com.commodity_id,
f.negotiation_creator_id,
f.category_id,
f.po_item_id,
f.supplier_id,
f.supplier_site_id,
f.quantity,
f.award_qty,
f.award_price,
f.current_price,
f.award_amount_t,
f.award_amount_b,
f.award_amount_g,
f.award_amount_sg,
f.current_amount_t,
f.current_amount_b,
f.current_amount_g,
f.current_amount_sg,
f.auction_status,
f.award_status,
f.allocation_status,
f.supplier_invite_date,
f.base_uom,
f.contract_type
FROM
POA.POA_DBI_NEG_F f,
FII.FII_TIME_DAY cal,
PO.PO_COMMODITY_CATEGORIES com
WHERE
trunc(f.award_complete_date) = cal.report_date
and f.category_id = com.category_id