VIEW: APPS.PAY_AU_LEAVE_LIABILITY_V

Source

View Text - Preformatted

SELECT aa.payroll_action_id payroll_action_id , aa.assignment_id assignment_id , aa.assignment_action_id assignment_action_id , ap.accrual_category accrual_category , to_number(LAcc.aicaapcontext) accrual_plan_id , to_number(Lent.aievalue) leave_entitlement , to_number(LEntV.aievvalue) entitlement_value , to_number(LAcc.aiavalue) leave_accrual , to_number(LAccV.aiavvalue) accrual_value from (Select ai_a.Context1 aiacontext1 ,aic_a_as.context aicaascontext ,aic_a_ap.context aicaapcontext ,ai_a.value aiavalue From ff_user_entities ue_a , ff_archive_items ai_a , ff_archive_item_contexts aic_a_as , ff_contexts c_a_as , ff_archive_item_contexts aic_a_ap , ff_contexts c_a_ap WHERE ue_a.user_entity_name = 'X_LEAVE_ACCRUAL' and ai_a.user_entity_id = ue_a.user_entity_id and aic_a_as.archive_item_id = ai_a.archive_item_id and c_a_as.context_name = 'ASSIGNMENT_ACTION_ID' and aic_a_as.context_id = c_a_as.context_id and aic_a_ap.archive_item_id = ai_a.archive_item_id and c_a_ap.context_name = 'ACCRUAL_PLAN_ID' and aic_a_ap.context_id = c_a_ap.context_id ) LAcc, (Select aic_e_as.Context aiceascontext, ai_e.context1 aiecontext1, aic_e_ap.context aiceapcontext, ai_e.value aievalue From ff_user_entities ue_e , ff_archive_items ai_e , ff_archive_item_contexts aic_e_as , ff_contexts c_e_as , ff_archive_item_contexts aic_e_ap , ff_contexts c_e_ap where ue_e.user_entity_name = 'X_LEAVE_ENTITLEMENT' and ai_e.user_entity_id = ue_e.user_entity_id and aic_e_as.archive_item_id = ai_e.archive_item_id and c_e_as.context_name = 'ASSIGNMENT_ACTION_ID' and aic_e_as.context_id = c_e_as.context_id and aic_e_ap.archive_item_id = ai_e.archive_item_id and c_e_ap.context_name = 'ACCRUAL_PLAN_ID' and aic_e_ap.context_id = c_e_ap.context_id )Lent, (Select aic_av_as.context aicavascontext ,ai_av.context1 aiavcontext1 ,aic_av_ap.context aicavapcontext ,ai_av.value aiavvalue From ff_user_entities ue_av , ff_archive_items ai_av , ff_archive_item_contexts aic_av_as , ff_contexts c_av_as , ff_archive_item_contexts aic_av_ap , ff_contexts c_av_ap Where ue_av.user_entity_name = 'X_ACCRUAL_VALUE' and ai_av.user_entity_id = ue_av.user_entity_id and aic_av_as.archive_item_id = ai_av.archive_item_id and c_av_as.context_name = 'ASSIGNMENT_ACTION_ID' and aic_av_as.context_id = c_av_as.context_id and aic_av_ap.archive_item_id = ai_av.archive_item_id and c_av_ap.context_name = 'ACCRUAL_PLAN_ID' and aic_av_ap.context_id = c_av_ap.context_id )LAccV, (Select ai_ev.context1 aievcontext1 ,aic_ev_as.context aicevascontext ,aic_ev_Ap.context aicevapcontext,ai_ev.value aievvalue from ff_user_entities ue_ev , ff_archive_items ai_ev , ff_archive_item_contexts aic_ev_as , ff_contexts c_ev_as , ff_archive_item_contexts aic_ev_ap , ff_contexts c_ev_ap where ue_ev.user_entity_name = 'X_ENTITLEMENT_VALUE' and ai_ev.user_entity_id = ue_ev.user_entity_id and aic_ev_as.archive_item_id = ai_ev.archive_item_id and c_ev_as.context_name = 'ASSIGNMENT_ACTION_ID' and aic_ev_as.context_id = c_ev_as.context_id and aic_ev_ap.archive_item_id = ai_ev.archive_item_id and c_ev_ap.context_name = 'ACCRUAL_PLAN_ID' and aic_ev_ap.context_id = c_ev_ap.context_id )LEntV , Pay_accrual_plans ap, Pay_assignment_actions aa where LAcc.aiacontext1 = aa.assignment_action_id and aa.assignment_action_id = aicaascontext and ap.accrual_plan_id = LAcc.aicaapcontext and Lent.aiceascontext = aa.assignment_action_id and Lent.aiecontext1 = aa.assignment_action_id and Lent.aiceapcontext = ap.accrual_plan_id and LAccV.aicavascontext = aa.assignment_action_id and LAccV.aiavcontext1 = aa.assignment_action_id and LAccV.aicavapcontext = ap.accrual_plan_id and LEntV.aievcontext1 = aa.assignment_action_id and LEntV.aicevascontext = aa.assignment_action_id and LEntV.aicevapcontext = ap.accrual_plan_id

View Text - HTML Formatted

SELECT AA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, AA.ASSIGNMENT_ID ASSIGNMENT_ID
, AA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, AP.ACCRUAL_CATEGORY ACCRUAL_CATEGORY
, TO_NUMBER(LACC.AICAAPCONTEXT) ACCRUAL_PLAN_ID
, TO_NUMBER(LENT.AIEVALUE) LEAVE_ENTITLEMENT
, TO_NUMBER(LENTV.AIEVVALUE) ENTITLEMENT_VALUE
, TO_NUMBER(LACC.AIAVALUE) LEAVE_ACCRUAL
, TO_NUMBER(LACCV.AIAVVALUE) ACCRUAL_VALUE
FROM (SELECT AI_A.CONTEXT1 AIACONTEXT1
, AIC_A_AS.CONTEXT AICAASCONTEXT
, AIC_A_AP.CONTEXT AICAAPCONTEXT
, AI_A.VALUE AIAVALUE
FROM FF_USER_ENTITIES UE_A
, FF_ARCHIVE_ITEMS AI_A
, FF_ARCHIVE_ITEM_CONTEXTS AIC_A_AS
, FF_CONTEXTS C_A_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_A_AP
, FF_CONTEXTS C_A_AP
WHERE UE_A.USER_ENTITY_NAME = 'X_LEAVE_ACCRUAL'
AND AI_A.USER_ENTITY_ID = UE_A.USER_ENTITY_ID
AND AIC_A_AS.ARCHIVE_ITEM_ID = AI_A.ARCHIVE_ITEM_ID
AND C_A_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID'
AND AIC_A_AS.CONTEXT_ID = C_A_AS.CONTEXT_ID
AND AIC_A_AP.ARCHIVE_ITEM_ID = AI_A.ARCHIVE_ITEM_ID
AND C_A_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID'
AND AIC_A_AP.CONTEXT_ID = C_A_AP.CONTEXT_ID ) LACC
, (SELECT AIC_E_AS.CONTEXT AICEASCONTEXT
, AI_E.CONTEXT1 AIECONTEXT1
, AIC_E_AP.CONTEXT AICEAPCONTEXT
, AI_E.VALUE AIEVALUE
FROM FF_USER_ENTITIES UE_E
, FF_ARCHIVE_ITEMS AI_E
, FF_ARCHIVE_ITEM_CONTEXTS AIC_E_AS
, FF_CONTEXTS C_E_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_E_AP
, FF_CONTEXTS C_E_AP
WHERE UE_E.USER_ENTITY_NAME = 'X_LEAVE_ENTITLEMENT'
AND AI_E.USER_ENTITY_ID = UE_E.USER_ENTITY_ID
AND AIC_E_AS.ARCHIVE_ITEM_ID = AI_E.ARCHIVE_ITEM_ID
AND C_E_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID'
AND AIC_E_AS.CONTEXT_ID = C_E_AS.CONTEXT_ID
AND AIC_E_AP.ARCHIVE_ITEM_ID = AI_E.ARCHIVE_ITEM_ID
AND C_E_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID'
AND AIC_E_AP.CONTEXT_ID = C_E_AP.CONTEXT_ID )LENT
, (SELECT AIC_AV_AS.CONTEXT AICAVASCONTEXT
, AI_AV.CONTEXT1 AIAVCONTEXT1
, AIC_AV_AP.CONTEXT AICAVAPCONTEXT
, AI_AV.VALUE AIAVVALUE
FROM FF_USER_ENTITIES UE_AV
, FF_ARCHIVE_ITEMS AI_AV
, FF_ARCHIVE_ITEM_CONTEXTS AIC_AV_AS
, FF_CONTEXTS C_AV_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_AV_AP
, FF_CONTEXTS C_AV_AP
WHERE UE_AV.USER_ENTITY_NAME = 'X_ACCRUAL_VALUE'
AND AI_AV.USER_ENTITY_ID = UE_AV.USER_ENTITY_ID
AND AIC_AV_AS.ARCHIVE_ITEM_ID = AI_AV.ARCHIVE_ITEM_ID
AND C_AV_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID'
AND AIC_AV_AS.CONTEXT_ID = C_AV_AS.CONTEXT_ID
AND AIC_AV_AP.ARCHIVE_ITEM_ID = AI_AV.ARCHIVE_ITEM_ID
AND C_AV_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID'
AND AIC_AV_AP.CONTEXT_ID = C_AV_AP.CONTEXT_ID )LACCV
, (SELECT AI_EV.CONTEXT1 AIEVCONTEXT1
, AIC_EV_AS.CONTEXT AICEVASCONTEXT
, AIC_EV_AP.CONTEXT AICEVAPCONTEXT
, AI_EV.VALUE AIEVVALUE
FROM FF_USER_ENTITIES UE_EV
, FF_ARCHIVE_ITEMS AI_EV
, FF_ARCHIVE_ITEM_CONTEXTS AIC_EV_AS
, FF_CONTEXTS C_EV_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_EV_AP
, FF_CONTEXTS C_EV_AP
WHERE UE_EV.USER_ENTITY_NAME = 'X_ENTITLEMENT_VALUE'
AND AI_EV.USER_ENTITY_ID = UE_EV.USER_ENTITY_ID
AND AIC_EV_AS.ARCHIVE_ITEM_ID = AI_EV.ARCHIVE_ITEM_ID
AND C_EV_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID'
AND AIC_EV_AS.CONTEXT_ID = C_EV_AS.CONTEXT_ID
AND AIC_EV_AP.ARCHIVE_ITEM_ID = AI_EV.ARCHIVE_ITEM_ID
AND C_EV_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID'
AND AIC_EV_AP.CONTEXT_ID = C_EV_AP.CONTEXT_ID )LENTV
, PAY_ACCRUAL_PLANS AP
, PAY_ASSIGNMENT_ACTIONS AA
WHERE LACC.AIACONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND AA.ASSIGNMENT_ACTION_ID = AICAASCONTEXT
AND AP.ACCRUAL_PLAN_ID = LACC.AICAAPCONTEXT
AND LENT.AICEASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LENT.AIECONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LENT.AICEAPCONTEXT = AP.ACCRUAL_PLAN_ID
AND LACCV.AICAVASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LACCV.AIAVCONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LACCV.AICAVAPCONTEXT = AP.ACCRUAL_PLAN_ID
AND LENTV.AIEVCONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LENTV.AICEVASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LENTV.AICEVAPCONTEXT = AP.ACCRUAL_PLAN_ID