PJC_LABOR_SCH_COSTS_SRC

Details

Schema: FUSION
Object owner: PJC
Object type: VIEW

Columns

Name
RUN_TARGET_ID PROJECT_ID PROJECT_NAME_ID PROJECT_NUMBER_ID SPONSORED_FLAG TASK_ID TASK_NAME_ID TASK_NUMBER_ID LINE_PERCENT BILLABLE_FLAG CAPITALIZABLE_FLAG CONTRACT_ID CONTRACT_NAME_ID CONTRACT_NUMBER_ID AWARD_OWNING_ORG_ID AWARD_OWNING_ORG_NAME_ID AWARDINSTITUTIONID AWARD_INSTITUTION_NAME_ID EXPORGANIZATIONID EXP_ORGANIZATION_NAME_ID EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_NAME_ID FUNDINGSOURCEID FUNDING_SOURCE_NAME_ID FUNDING_SOURCE_NUMBER_ID FUNDINGSOURCETYPECODE FUNDINGSOURCETYPE LDTARGETCCID GLACCOUNT DISTRULETYPECODE DISTRIBUTIONRULETYPE BUSINESSUNITID BUSINESS_UNIT_NAME_ID RULE_ID LINENUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRTIMESTAMP1 ATTRTIMESTAMP2 ATTRTIMESTAMP3 ATTRTIMESTAMP4 ATTRTIMESTAMP5 ATTRTIMESTAMP6 ATTRTIMESTAMP7 ATTRTIMESTAMP8 ATTRTIMESTAMP9 ATTRTIMESTAMP10 TIMECARD_DIST_FLAG TOTALALLOCATION RUN_ID LD_INTERFACE_ID CURRENCYCODE PAYROLL_ID PAYROLL_NAME_ID PAY_AMOUNT PERIOD_START_DATE PERIOD_END_DATE OCCUR_PAY_PERIOD_START_DATE OCCUR_PAY_PERIOD_END_DATE LEGISLATIVEDATAGROUPID LDG_NAME_ID PAYELEMENTTYPEID PAY_ELEMENT_REPORTING_NAME_ID PAY_ELEMENT_NAME_ID COSTINGSEGMENTS1 COSTINGSEGMENTS2 COSTINGSEGMENTS3 COSTINGSEGMENTS4 COSTINGSEGMENTS5 COSTINGSEGMENTS6 COSTINGSEGMENTS7 COSTINGSEGMENTS8 COSTINGSEGMENTS9 COSTINGSEGMENTS10 COSTINGSEGMENTS11 COSTINGSEGMENTS12 COSTINGSEGMENTS13 COSTINGSEGMENTS14 COSTINGSEGMENTS15 COSTINGSEGMENTS16 COSTINGSEGMENTS17 COSTINGSEGMENTS18 COSTINGSEGMENTS19 COSTINGSEGMENTS20 COSTINGSEGMENTS21 COSTINGSEGMENTS22 COSTINGSEGMENTS23 COSTINGSEGMENTS24 COSTINGSEGMENTS25 COSTINGSEGMENTS26 COSTINGSEGMENTS27 COSTINGSEGMENTS28 COSTINGSEGMENTS29 COSTINGSEGMENTS30

Name

RUN_TARGET_ID

PROJECT_ID

PROJECT_NAME_ID

PROJECT_NUMBER_ID

SPONSORED_FLAG

TASK_ID

TASK_NAME_ID

TASK_NUMBER_ID

LINE_PERCENT

BILLABLE_FLAG

CAPITALIZABLE_FLAG

CONTRACT_ID

CONTRACT_NAME_ID

CONTRACT_NUMBER_ID

AWARD_OWNING_ORG_ID

AWARD_OWNING_ORG_NAME_ID

AWARDINSTITUTIONID

AWARD_INSTITUTION_NAME_ID

EXPORGANIZATIONID

EXP_ORGANIZATION_NAME_ID

EXPENDITURE_TYPE_ID

EXPENDITURE_TYPE_NAME_ID

FUNDINGSOURCEID

FUNDING_SOURCE_NAME_ID

FUNDING_SOURCE_NUMBER_ID

FUNDINGSOURCETYPECODE

FUNDINGSOURCETYPE

LDTARGETCCID

GLACCOUNT

DISTRULETYPECODE

DISTRIBUTIONRULETYPE

BUSINESSUNITID

BUSINESS_UNIT_NAME_ID

RULE_ID

LINENUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRTIMESTAMP1

ATTRTIMESTAMP2

ATTRTIMESTAMP3

ATTRTIMESTAMP4

ATTRTIMESTAMP5

ATTRTIMESTAMP6

ATTRTIMESTAMP7

ATTRTIMESTAMP8

ATTRTIMESTAMP9

ATTRTIMESTAMP10

TIMECARD_DIST_FLAG

TOTALALLOCATION

RUN_ID

LD_INTERFACE_ID

CURRENCYCODE

PAYROLL_ID

PAYROLL_NAME_ID

PAY_AMOUNT

PERIOD_START_DATE

PERIOD_END_DATE

OCCUR_PAY_PERIOD_START_DATE

OCCUR_PAY_PERIOD_END_DATE

LEGISLATIVEDATAGROUPID

LDG_NAME_ID

PAYELEMENTTYPEID

PAY_ELEMENT_REPORTING_NAME_ID

PAY_ELEMENT_NAME_ID

COSTINGSEGMENTS1

COSTINGSEGMENTS2

COSTINGSEGMENTS3

COSTINGSEGMENTS4

COSTINGSEGMENTS5

COSTINGSEGMENTS6

COSTINGSEGMENTS7

COSTINGSEGMENTS8

COSTINGSEGMENTS9

COSTINGSEGMENTS10

COSTINGSEGMENTS11

COSTINGSEGMENTS12

COSTINGSEGMENTS13

COSTINGSEGMENTS14

COSTINGSEGMENTS15

COSTINGSEGMENTS16

COSTINGSEGMENTS17

COSTINGSEGMENTS18

COSTINGSEGMENTS19

COSTINGSEGMENTS20

COSTINGSEGMENTS21

COSTINGSEGMENTS22

COSTINGSEGMENTS23

COSTINGSEGMENTS24

COSTINGSEGMENTS25

COSTINGSEGMENTS26

COSTINGSEGMENTS27

COSTINGSEGMENTS28

COSTINGSEGMENTS29

COSTINGSEGMENTS30

Query

SQL_Statement
SELECT LaborDistRunTargetsPEO.run_target_id, LaborDistRunTargetsPEO.project_id, LaborDistRunTargetsPEO.project_id Project_Name_Id, LaborDistRunTargetsPEO.project_id Project_Number_Id, pjfprojecttypesvl.sponsored_flag, LaborDistRunTargetsPEO.task_id, LaborDistRunTargetsPEO.task_id Task_Name_Id, LaborDistRunTargetsPEO.task_id Task_Number_Id, LaborDistRunTargetsPEO.line_percent, LaborDistRunTargetsPEO.billable_flag, LaborDistRunTargetsPEO.capitalizable_flag, LaborDistRunTargetsPEO.contract_id, LaborDistRunTargetsPEO.contract_id Contract_Name_Id, LaborDistRunTargetsPEO.contract_id Contract_Number_Id, awardheadereo.award_owning_org_id, awardheadereo.award_owning_org_id Award_Owning_Org_Name_Id, awardheadereo.institution_id AwardInstitutionId, awardheadereo.institution_id Award_Institution_Name_Id, LaborDistRunTargetsPEO.organization_id ExpOrganizationId, LaborDistRunTargetsPEO.organization_id Exp_Organization_Name_Id, LaborDistRunTargetsPEO.expenditure_type_id, LaborDistRunTargetsPEO.expenditure_type_id Expenditure_Type_Name_Id, LaborDistRunTargetsPEO.reserved_Attribute1 FundingSourceId, LaborDistRunTargetsPEO.reserved_Attribute1 Funding_Source_Name_Id, LaborDistRunTargetsPEO.reserved_Attribute1 Funding_Source_Number_Id, fundingsourceallpeo.type FundingSourceTypeCode, fundingsourceallpeo.funding_source_type FundingSourceType, LaborDistRunTargetsPEO.ld_target_ccid LdTargetCCID, codecombinationeo.concatenated_segments GlAccount, projectldschrulesalleo.type DistRuleTypeCode, distributionruletypelookuppeo.meaning DistributionRuleType, projectldschrulesalleo.org_id BusinessUnitId, projectldschrulesalleo.org_id Business_Unit_Name_Id, LaborDistRunTargetsPEO.rule_id, LaborDistRunTargetsPEO.line_num LineNumber, projectldschtargetlineseo.Attribute_Category, projectldschtargetlineseo.Attribute1, projectldschtargetlineseo.Attribute2, projectldschtargetlineseo.Attribute3, projectldschtargetlineseo.Attribute4, projectldschtargetlineseo.Attribute5, projectldschtargetlineseo.Attribute6, projectldschtargetlineseo.Attribute7, projectldschtargetlineseo.Attribute8, projectldschtargetlineseo.Attribute9, projectldschtargetlineseo.Attribute10, projectldschtargetlineseo.Attribute11, projectldschtargetlineseo.Attribute12, projectldschtargetlineseo.Attribute13, projectldschtargetlineseo.Attribute14, projectldschtargetlineseo.Attribute15, projectldschtargetlineseo.Attribute16, projectldschtargetlineseo.Attribute17, projectldschtargetlineseo.Attribute18, projectldschtargetlineseo.Attribute19, projectldschtargetlineseo.Attribute20, projectldschtargetlineseo.Attribute_Date1, projectldschtargetlineseo.Attribute_Date2, projectldschtargetlineseo.Attribute_Date3, projectldschtargetlineseo.Attribute_Date4, projectldschtargetlineseo.Attribute_Date5, projectldschtargetlineseo.Attribute_Date6, projectldschtargetlineseo.Attribute_Date7, projectldschtargetlineseo.Attribute_Date8, projectldschtargetlineseo.Attribute_Date9, projectldschtargetlineseo.Attribute_Date10, projectldschtargetlineseo.Attribute_Number1, projectldschtargetlineseo.Attribute_Number2, projectldschtargetlineseo.Attribute_Number3, projectldschtargetlineseo.Attribute_Number4, projectldschtargetlineseo.Attribute_Number5, projectldschtargetlineseo.Attribute_Number6, projectldschtargetlineseo.Attribute_Number7, projectldschtargetlineseo.Attribute_Number8, projectldschtargetlineseo.Attribute_Number9, projectldschtargetlineseo.Attribute_Number10, projectldschtargetlineseo.Attribute_timestamp1 AttrTimestamp1, projectldschtargetlineseo.Attribute_timestamp2 AttrTimestamp2, projectldschtargetlineseo.Attribute_timestamp3 AttrTimestamp3, projectldschtargetlineseo.Attribute_timestamp4 AttrTimestamp4, projectldschtargetlineseo.Attribute_timestamp5 AttrTimestamp5, projectldschtargetlineseo.Attribute_timestamp6 AttrTimestamp6, projectldschtargetlineseo.Attribute_timestamp7 AttrTimestamp7, projectldschtargetlineseo.Attribute_timestamp8 AttrTimestamp8, projectldschtargetlineseo.Attribute_timestamp9 AttrTimestamp9, projectldschtargetlineseo.Attribute_timestamp10 AttrTimestamp10, LaborDistRunTargetsPEO.timecard_dist_flag, labordistrunsallpeo.total_pool_amount * ( LaborDistRunTargetsPEO.line_percent / 100 ) AS TotalAllocation, LaborDistRunTargetsPEO.run_id, labordistributionintpeo.ld_interface_id, labordistributionintpeo.currency_code currencycode, labordistributionintpeo.payroll_id, labordistributionintpeo.payroll_id Payroll_Name_Id, labordistributionintpeo.pay_amount, labordistributionintpeo.period_start_date, labordistributionintpeo.period_end_date, labordistributionintpeo.occur_pay_period_start_date, labordistributionintpeo.occur_pay_period_end_date, elementtypedpeo.legislative_data_group_id LegislativeDataGroupId, elementtypedpeo.legislative_data_group_id LDG_Name_Id, labordistrunsallpeo.ld_element_type_id PayElementTypeId, labordistrunsallpeo.ld_element_type_id Pay_Element_Reporting_Name_Id, labordistrunsallpeo.ld_element_type_id Pay_Element_Name_Id, labordistributionintpeo.segment1 CostingSegments1, labordistributionintpeo.segment2 CostingSegments2, labordistributionintpeo.segment3 CostingSegments3, labordistributionintpeo.segment4 CostingSegments4, labordistributionintpeo.segment5 CostingSegments5, labordistributionintpeo.segment6 CostingSegments6, labordistributionintpeo.segment7 CostingSegments7, labordistributionintpeo.segment8 CostingSegments8, labordistributionintpeo.segment9 CostingSegments9, labordistributionintpeo.segment10 CostingSegments10, labordistributionintpeo.segment11 CostingSegments11, labordistributionintpeo.segment12 CostingSegments12, labordistributionintpeo.segment13 CostingSegments13, labordistributionintpeo.segment14 CostingSegments14, labordistributionintpeo.segment15 CostingSegments15, labordistributionintpeo.segment16 CostingSegments16, labordistributionintpeo.segment17 CostingSegments17, labordistributionintpeo.segment18 CostingSegments18, labordistributionintpeo.segment19 CostingSegments19, labordistributionintpeo.segment20 CostingSegments20, labordistributionintpeo.segment21 CostingSegments21, labordistributionintpeo.segment22 CostingSegments22, labordistributionintpeo.segment23 CostingSegments23, labordistributionintpeo.segment24 CostingSegments24, labordistributionintpeo.segment25 CostingSegments25, labordistributionintpeo.segment26 CostingSegments26, labordistributionintpeo.segment27 CostingSegments27, labordistributionintpeo.segment28 CostingSegments28, labordistributionintpeo.segment29 CostingSegments29, labordistributionintpeo.segment30 CostingSegments30 FROM pjc_alloc_run_targets LaborDistRunTargetsPEO, pjc_alloc_runs_all labordistrunsallpeo, pjf_projects_all_vl projectpeo, gms_funding_sources_all_v fundingsourceallpeo, pjf_project_types_vl pjfprojecttypesvl, pjc_labor_distribution_int labordistributionintpeo, gms_award_headers_vl awardheadereo, pjc_alloc_rules_all projectldschrulesalleo, pjc_ld_sch_target_lines projectldschtargetlineseo, pay_element_types_vl elementtypedpeo, gl_code_combinations codecombinationeo, pjc_lookups distributionruletypelookuppeo WHERE LaborDistRunTargetsPEO.contract_id = awardheadereo.id (+) AND LaborDistRunTargetsPEO.run_id = labordistrunsallpeo.run_id AND LaborDistRunTargetsPEO.project_id = projectpeo.project_id (+) AND LaborDistRunTargetsPEO.reserved_Attribute1 = fundingsourceallpeo.funding_source_id (+) AND labordistrunsallpeo.ld_interface_id = labordistributionintpeo.ld_interface_id (+) AND labordistrunsallpeo.ld_orig_transaction_reference IS NOT NULL AND projectpeo.project_type_id = pjfprojecttypesvl.project_type_id (+) AND LaborDistRunTargetsPEO.rule_id = projectldschrulesalleo.rule_id AND LaborDistRunTargetsPEO.rule_id = projectldschtargetlineseo.rule_id (+) AND LaborDistRunTargetsPEO.line_num = projectldschtargetlineseo.line_number (+) AND labordistrunsallpeo.ld_element_type_id = elementtypedpeo.element_type_id AND LaborDistRunTargetsPEO.ld_target_ccid = codecombinationeo.code_combination_id (+) AND projectldschrulesalleo.type = distributionruletypelookuppeo.lookup_code (+) AND distributionruletypelookuppeo.lookup_type = 'ORA_PJC_LD_SCH_TYPE'

SQL_Statement

SELECT

LaborDistRunTargetsPEO.run_target_id,

LaborDistRunTargetsPEO.project_id,

LaborDistRunTargetsPEO.project_id Project_Name_Id,

LaborDistRunTargetsPEO.project_id Project_Number_Id,

pjfprojecttypesvl.sponsored_flag,

LaborDistRunTargetsPEO.task_id,

LaborDistRunTargetsPEO.task_id Task_Name_Id,

LaborDistRunTargetsPEO.task_id Task_Number_Id,

LaborDistRunTargetsPEO.line_percent,

LaborDistRunTargetsPEO.billable_flag,

LaborDistRunTargetsPEO.capitalizable_flag,

LaborDistRunTargetsPEO.contract_id,

LaborDistRunTargetsPEO.contract_id Contract_Name_Id,

LaborDistRunTargetsPEO.contract_id Contract_Number_Id,

awardheadereo.award_owning_org_id,

awardheadereo.award_owning_org_id Award_Owning_Org_Name_Id,

awardheadereo.institution_id AwardInstitutionId,

awardheadereo.institution_id Award_Institution_Name_Id,

LaborDistRunTargetsPEO.organization_id ExpOrganizationId,

LaborDistRunTargetsPEO.organization_id Exp_Organization_Name_Id,

LaborDistRunTargetsPEO.expenditure_type_id,

LaborDistRunTargetsPEO.expenditure_type_id Expenditure_Type_Name_Id,

LaborDistRunTargetsPEO.reserved_Attribute1 FundingSourceId,

LaborDistRunTargetsPEO.reserved_Attribute1 Funding_Source_Name_Id,

LaborDistRunTargetsPEO.reserved_Attribute1 Funding_Source_Number_Id,

fundingsourceallpeo.type FundingSourceTypeCode,

fundingsourceallpeo.funding_source_type FundingSourceType,

LaborDistRunTargetsPEO.ld_target_ccid LdTargetCCID,

codecombinationeo.concatenated_segments GlAccount,

projectldschrulesalleo.type DistRuleTypeCode,

distributionruletypelookuppeo.meaning DistributionRuleType,

projectldschrulesalleo.org_id BusinessUnitId,

projectldschrulesalleo.org_id Business_Unit_Name_Id,

LaborDistRunTargetsPEO.rule_id,

LaborDistRunTargetsPEO.line_num LineNumber,

projectldschtargetlineseo.Attribute_Category,

projectldschtargetlineseo.Attribute1,

projectldschtargetlineseo.Attribute2,

projectldschtargetlineseo.Attribute3,

projectldschtargetlineseo.Attribute4,

projectldschtargetlineseo.Attribute5,

projectldschtargetlineseo.Attribute6,

projectldschtargetlineseo.Attribute7,

projectldschtargetlineseo.Attribute8,

projectldschtargetlineseo.Attribute9,

projectldschtargetlineseo.Attribute10,

projectldschtargetlineseo.Attribute11,

projectldschtargetlineseo.Attribute12,

projectldschtargetlineseo.Attribute13,

projectldschtargetlineseo.Attribute14,

projectldschtargetlineseo.Attribute15,

projectldschtargetlineseo.Attribute16,

projectldschtargetlineseo.Attribute17,

projectldschtargetlineseo.Attribute18,

projectldschtargetlineseo.Attribute19,

projectldschtargetlineseo.Attribute20,

projectldschtargetlineseo.Attribute_Date1,

projectldschtargetlineseo.Attribute_Date2,

projectldschtargetlineseo.Attribute_Date3,

projectldschtargetlineseo.Attribute_Date4,

projectldschtargetlineseo.Attribute_Date5,

projectldschtargetlineseo.Attribute_Date6,

projectldschtargetlineseo.Attribute_Date7,

projectldschtargetlineseo.Attribute_Date8,

projectldschtargetlineseo.Attribute_Date9,

projectldschtargetlineseo.Attribute_Date10,

projectldschtargetlineseo.Attribute_Number1,

projectldschtargetlineseo.Attribute_Number2,

projectldschtargetlineseo.Attribute_Number3,

projectldschtargetlineseo.Attribute_Number4,

projectldschtargetlineseo.Attribute_Number5,

projectldschtargetlineseo.Attribute_Number6,

projectldschtargetlineseo.Attribute_Number7,

projectldschtargetlineseo.Attribute_Number8,

projectldschtargetlineseo.Attribute_Number9,

projectldschtargetlineseo.Attribute_Number10,

projectldschtargetlineseo.Attribute_timestamp1 AttrTimestamp1,

projectldschtargetlineseo.Attribute_timestamp2 AttrTimestamp2,

projectldschtargetlineseo.Attribute_timestamp3 AttrTimestamp3,

projectldschtargetlineseo.Attribute_timestamp4 AttrTimestamp4,

projectldschtargetlineseo.Attribute_timestamp5 AttrTimestamp5,

projectldschtargetlineseo.Attribute_timestamp6 AttrTimestamp6,

projectldschtargetlineseo.Attribute_timestamp7 AttrTimestamp7,

projectldschtargetlineseo.Attribute_timestamp8 AttrTimestamp8,

projectldschtargetlineseo.Attribute_timestamp9 AttrTimestamp9,

projectldschtargetlineseo.Attribute_timestamp10 AttrTimestamp10,

LaborDistRunTargetsPEO.timecard_dist_flag,

labordistrunsallpeo.total_pool_amount * ( LaborDistRunTargetsPEO.line_percent / 100 ) AS TotalAllocation,

LaborDistRunTargetsPEO.run_id,

labordistributionintpeo.ld_interface_id,

labordistributionintpeo.currency_code currencycode,

labordistributionintpeo.payroll_id,

labordistributionintpeo.payroll_id Payroll_Name_Id,

labordistributionintpeo.pay_amount,

labordistributionintpeo.period_start_date,

labordistributionintpeo.period_end_date,

labordistributionintpeo.occur_pay_period_start_date,

labordistributionintpeo.occur_pay_period_end_date,

elementtypedpeo.legislative_data_group_id LegislativeDataGroupId,

elementtypedpeo.legislative_data_group_id LDG_Name_Id,

labordistrunsallpeo.ld_element_type_id PayElementTypeId,

labordistrunsallpeo.ld_element_type_id Pay_Element_Reporting_Name_Id,

labordistrunsallpeo.ld_element_type_id Pay_Element_Name_Id,

labordistributionintpeo.segment1 CostingSegments1,

labordistributionintpeo.segment2 CostingSegments2,

labordistributionintpeo.segment3 CostingSegments3,

labordistributionintpeo.segment4 CostingSegments4,

labordistributionintpeo.segment5 CostingSegments5,

labordistributionintpeo.segment6 CostingSegments6,

labordistributionintpeo.segment7 CostingSegments7,

labordistributionintpeo.segment8 CostingSegments8,

labordistributionintpeo.segment9 CostingSegments9,

labordistributionintpeo.segment10 CostingSegments10,

labordistributionintpeo.segment11 CostingSegments11,

labordistributionintpeo.segment12 CostingSegments12,

labordistributionintpeo.segment13 CostingSegments13,

labordistributionintpeo.segment14 CostingSegments14,

labordistributionintpeo.segment15 CostingSegments15,

labordistributionintpeo.segment16 CostingSegments16,

labordistributionintpeo.segment17 CostingSegments17,

labordistributionintpeo.segment18 CostingSegments18,

labordistributionintpeo.segment19 CostingSegments19,

labordistributionintpeo.segment20 CostingSegments20,

labordistributionintpeo.segment21 CostingSegments21,

labordistributionintpeo.segment22 CostingSegments22,

labordistributionintpeo.segment23 CostingSegments23,

labordistributionintpeo.segment24 CostingSegments24,

labordistributionintpeo.segment25 CostingSegments25,

labordistributionintpeo.segment26 CostingSegments26,

labordistributionintpeo.segment27 CostingSegments27,

labordistributionintpeo.segment28 CostingSegments28,

labordistributionintpeo.segment29 CostingSegments29,

labordistributionintpeo.segment30 CostingSegments30

FROM

pjc_alloc_run_targets LaborDistRunTargetsPEO,

pjc_alloc_runs_all labordistrunsallpeo,

pjf_projects_all_vl projectpeo,

gms_funding_sources_all_v fundingsourceallpeo,

pjf_project_types_vl pjfprojecttypesvl,

pjc_labor_distribution_int labordistributionintpeo,

gms_award_headers_vl awardheadereo,

pjc_alloc_rules_all projectldschrulesalleo,

pjc_ld_sch_target_lines projectldschtargetlineseo,

pay_element_types_vl elementtypedpeo,

gl_code_combinations codecombinationeo,

pjc_lookups distributionruletypelookuppeo

WHERE

LaborDistRunTargetsPEO.contract_id = awardheadereo.id (+)

AND LaborDistRunTargetsPEO.run_id = labordistrunsallpeo.run_id

AND LaborDistRunTargetsPEO.project_id = projectpeo.project_id (+)

AND LaborDistRunTargetsPEO.reserved_Attribute1 = fundingsourceallpeo.funding_source_id (+)

AND labordistrunsallpeo.ld_interface_id = labordistributionintpeo.ld_interface_id (+)

AND labordistrunsallpeo.ld_orig_transaction_reference IS NOT NULL

AND projectpeo.project_type_id = pjfprojecttypesvl.project_type_id (+)

AND LaborDistRunTargetsPEO.rule_id = projectldschrulesalleo.rule_id

AND LaborDistRunTargetsPEO.rule_id = projectldschtargetlineseo.rule_id (+)

AND LaborDistRunTargetsPEO.line_num = projectldschtargetlineseo.line_number (+)

AND labordistrunsallpeo.ld_element_type_id = elementtypedpeo.element_type_id

AND LaborDistRunTargetsPEO.ld_target_ccid = codecombinationeo.code_combination_id (+)

AND projectldschrulesalleo.type = distributionruletypelookuppeo.lookup_code (+)

AND distributionruletypelookuppeo.lookup_type = 'ORA_PJC_LD_SCH_TYPE'