VIEW: APPS.PO_SP_UNIQUE_VAL_V

Source

View Text - Preformatted

SELECT DISTINCT po_number, po_header_id, po_line_id, line_number FROM po_sp_val_v WHERE person_id = fnd_profile.Value('OTL_TK_RESOURCE_ID') AND To_date(fnd_profile.Value('OTL_TK_START_DATE'), 'DD-MON-RR') <= pol_expiration_date AND To_date(fnd_profile.Value('OTL_TK_END_DATE'), 'DD-MON-RR') >= pol_start_date AND To_date(fnd_profile.Value('OTL_TK_START_DATE'), 'DD-MON-RR') <= assignmt_effective_end_date AND To_date(fnd_profile.Value('OTL_TK_END_DATE'), 'DD-MON-RR') >= assignmt_effective_start_date AND business_group_id = hr_general.get_business_group_id AND ( ( validate_project_flag = 'Y' AND project_id IS NOT NULL AND task_id IS NOT NULL ) OR ( validate_project_flag = 'N' AND project_id = fnd_profile.Value('OTL_TK_ATTR_1') AND task_id = fnd_profile.Value('OTL_TK_ATTR_2') ) ) AND org_id = hxc_timecard_properties.Setup_mo_global_params( fnd_profile.Value('OTL_TK_RESOURCE_ID'))

View Text - HTML Formatted

SELECT DISTINCT PO_NUMBER
, PO_HEADER_ID
, PO_LINE_ID
, LINE_NUMBER
FROM PO_SP_VAL_V
WHERE PERSON_ID = FND_PROFILE.VALUE('OTL_TK_RESOURCE_ID')
AND TO_DATE(FND_PROFILE.VALUE('OTL_TK_START_DATE')
, 'DD-MON-RR') <= POL_EXPIRATION_DATE
AND TO_DATE(FND_PROFILE.VALUE('OTL_TK_END_DATE')
, 'DD-MON-RR') >= POL_START_DATE
AND TO_DATE(FND_PROFILE.VALUE('OTL_TK_START_DATE')
, 'DD-MON-RR') <= ASSIGNMT_EFFECTIVE_END_DATE
AND TO_DATE(FND_PROFILE.VALUE('OTL_TK_END_DATE')
, 'DD-MON-RR') >= ASSIGNMT_EFFECTIVE_START_DATE
AND BUSINESS_GROUP_ID = HR_GENERAL.GET_BUSINESS_GROUP_ID
AND ( ( VALIDATE_PROJECT_FLAG = 'Y'
AND PROJECT_ID IS NOT NULL
AND TASK_ID IS NOT NULL ) OR ( VALIDATE_PROJECT_FLAG = 'N'
AND PROJECT_ID = FND_PROFILE.VALUE('OTL_TK_ATTR_1')
AND TASK_ID = FND_PROFILE.VALUE('OTL_TK_ATTR_2') ) )
AND ORG_ID = HXC_TIMECARD_PROPERTIES.SETUP_MO_GLOBAL_PARAMS( FND_PROFILE.VALUE('OTL_TK_RESOURCE_ID'))