VIEW: APPS.PON_BUYER_MANAGE_DELIV_V

Source

View Text - Preformatted

SELECT bh.bid_number bid_number, fnd_user.user_id user_id from pon_auction_headers_all ah ,pon_bid_headers bh ,fnd_user fnd_user ,hz_parties user_parties ,hz_parties company_parties ,hz_relationships ,hz_code_assignments WHERE (ah.auction_status = 'ACTIVE' OR ah.auction_status = 'AUCTION_CLOSED') and fnd_user.person_party_id = user_parties.party_id and hz_relationships.object_id = company_parties.party_id and hz_relationships.subject_id = user_parties.party_id and hz_relationships.relationship_type = 'POS_EMPLOYMENT' and hz_relationships.relationship_code = 'EMPLOYEE_OF' and hz_relationships.start_date <= SYSDATE and hz_relationships.end_date >= SYSDATE and hz_code_assignments.owner_table_id = company_parties.party_id and hz_code_assignments.owner_table_name = 'HZ_PARTIES' and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE' and hz_code_assignments.class_code = 'ENTERPRISE' and company_parties.party_id = ah.trading_partner_id and bh.auction_header_id = ah.auction_header_id and bh.bid_status = 'ACTIVE' and( ( ( ah.trading_partner_contact_id = user_parties.party_id and ( ( ah.bid_visibility_code = 'OPEN_BIDDING' OR ah.bid_visibility_code = 'SEALED_BIDDING' ) OR ( ah.bid_visibility_code = 'SEALED_AUCTION' and nvl(ah.sealed_auction_status, 'LOCKED') <> 'LOCKED' )))) OR (ah.trading_partner_contact_id <> user_parties.party_id and ( (nvl (ah.security_level_code, 'PUBLIC') = 'PUBLIC' and fnd_user.user_id NOT IN ( select team.user_id from pon_neg_team_members team ,fnd_menus menu ,fnd_form_functions func ,fnd_compiled_menu_functions entry where team.menu_name = menu.menu_name and menu.menu_id = entry.menu_id and entry.function_id = func.function_id and func.function_name = 'PON_AUC_VIEWNEG' and team.auction_header_id = ah.auction_header_id ) ) or fnd_user.user_id IN ( select team.user_id from pon_neg_team_members team ,fnd_menus menu ,fnd_form_functions func ,fnd_compiled_menu_functions entry where team.menu_name = menu.menu_name and menu.menu_id = entry.menu_id and entry.function_id = func.function_id and func.function_name = 'PON_AUC_EDITNEG' and team.auction_header_id = ah.auction_header_id ) ) ))

View Text - HTML Formatted

SELECT BH.BID_NUMBER BID_NUMBER
, FND_USER.USER_ID USER_ID
FROM PON_AUCTION_HEADERS_ALL AH
, PON_BID_HEADERS BH
, FND_USER FND_USER
, HZ_PARTIES USER_PARTIES
, HZ_PARTIES COMPANY_PARTIES
, HZ_RELATIONSHIPS
, HZ_CODE_ASSIGNMENTS
WHERE (AH.AUCTION_STATUS = 'ACTIVE' OR AH.AUCTION_STATUS = 'AUCTION_CLOSED')
AND FND_USER.PERSON_PARTY_ID = USER_PARTIES.PARTY_ID
AND HZ_RELATIONSHIPS.OBJECT_ID = COMPANY_PARTIES.PARTY_ID
AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = COMPANY_PARTIES.PARTY_ID
AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
AND COMPANY_PARTIES.PARTY_ID = AH.TRADING_PARTNER_ID
AND BH.AUCTION_HEADER_ID = AH.AUCTION_HEADER_ID
AND BH.BID_STATUS = 'ACTIVE' AND( ( ( AH.TRADING_PARTNER_CONTACT_ID = USER_PARTIES.PARTY_ID
AND ( ( AH.BID_VISIBILITY_CODE = 'OPEN_BIDDING' OR AH.BID_VISIBILITY_CODE = 'SEALED_BIDDING' ) OR ( AH.BID_VISIBILITY_CODE = 'SEALED_AUCTION'
AND NVL(AH.SEALED_AUCTION_STATUS
, 'LOCKED') <> 'LOCKED' )))) OR (AH.TRADING_PARTNER_CONTACT_ID <> USER_PARTIES.PARTY_ID
AND ( (NVL (AH.SECURITY_LEVEL_CODE
, 'PUBLIC') = 'PUBLIC'
AND FND_USER.USER_ID NOT IN ( SELECT TEAM.USER_ID
FROM PON_NEG_TEAM_MEMBERS TEAM
, FND_MENUS MENU
, FND_FORM_FUNCTIONS FUNC
, FND_COMPILED_MENU_FUNCTIONS ENTRY
WHERE TEAM.MENU_NAME = MENU.MENU_NAME
AND MENU.MENU_ID = ENTRY.MENU_ID
AND ENTRY.FUNCTION_ID = FUNC.FUNCTION_ID
AND FUNC.FUNCTION_NAME = 'PON_AUC_VIEWNEG'
AND TEAM.AUCTION_HEADER_ID = AH.AUCTION_HEADER_ID ) ) OR FND_USER.USER_ID IN ( SELECT TEAM.USER_ID
FROM PON_NEG_TEAM_MEMBERS TEAM
, FND_MENUS MENU
, FND_FORM_FUNCTIONS FUNC
, FND_COMPILED_MENU_FUNCTIONS ENTRY
WHERE TEAM.MENU_NAME = MENU.MENU_NAME
AND MENU.MENU_ID = ENTRY.MENU_ID
AND ENTRY.FUNCTION_ID = FUNC.FUNCTION_ID
AND FUNC.FUNCTION_NAME = 'PON_AUC_EDITNEG'
AND TEAM.AUCTION_HEADER_ID = AH.AUCTION_HEADER_ID ) ) ))