1. Tables and Views for Project Management
  2. PJC_XLA_LD_COST_V

PJC_XLA_LD_COST_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

LD_TXN_ID

PERSON_ID

PERSON_NAME

PERSON_NUMBER

ASSIGNMENT_ID

ASSIGNMENT_NUMBER

ASSIGNMENT_NAME

Query

SQL_Statement

SELECT

ld.ld_txn_id,

ld.person_id,

Personname.list_name person_name,

person.person_number,

ld.assignment_id,

personassignment.assignment_number,

personassignment.assignment_name

FROM

pjc_labor_dist_txn_details ld,

per_all_people_f person,

per_all_assignments_f personassignment,

per_person_names_f_v personname

WHERE

ld.person_id = person.person_id

AND trunc(SYSDATE) BETWEEN trunc(person.effective_start_date) AND trunc(person.effective_end_date)

AND personassignment.person_id = ld.person_id

and personassignment.assignment_id = ld.assignment_id

AND trunc(SYSDATE) BETWEEN trunc(personassignment.effective_start_date) AND trunc(personassignment.effective_end_date)

AND personname.person_id = person.person_id

AND trunc(SYSDATE) BETWEEN trunc(personname.effective_start_date) AND trunc(personname.effective_end_date)