View: PON_BUYER_MANAGE_DELIV_V

Product:	PON - Sourcing
Description:
Implementation/DBA Data:	APPS.PON_BUYER_MANAGE_DELIV_V

View Text

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 ) ) ))

Columns