AME Task
This category groups 16 relationships in the Ramco Aviation domain.
Edges
HAS_SUBTASK — Task → SubTask (no automatic join)
Task contains subtasks
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGWU_SUBTSK_DTL
HAS_SIGNOFF — Task → TaskSignOff
Task has sign-off record
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGTSO_TSK_SNOFF
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGTSO_TSK_SNOFF.TLGTSO_WU_Track_id - Inference:
parent_pk_in_child
HAS_PART_CONSUMPTION — Task → PartConsumption
Task has part consumption records
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGPC_PART_CONSUMP_DTL
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGPC_PART_CONSUMP_DTL.TLGPC_TASK_Track_id - Inference:
parent_pk_in_child
HAS_RESOURCE_CONSUMPTION — Task → ResourceConsumption
Task has resource consumption records
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGRC_RES_CONSUMP_DTL
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGRC_RES_CONSUMP_DTL.TLGRC_TASK_Track_id - Inference:
parent_pk_in_child
ADDITIONAL_SIGNOFF — Task → AdditionalSignOff (no automatic join)
Task has additional sign-off
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: flog_adlsoff_tsk_dtl
HAS_WORK_ASSIGNMENT — Task → WorkAssignment
Task has work assignment
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_WORK_ASSIGN_DTL
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_WORK_ASSIGN_DTL.FLOG_TASK_tRACK_ID - Inference:
parent_pk_in_child
HAS_PARAM_UPDATE — Task → ParamUpdateDetail
Task has parameter update details
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: flog_tlgpm_param_upd_dtl
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_tlgpm_param_upd_dtl.TLGPM_Wu_Track_id - Inference:
parent_pk_in_child
HAS_SERIAL_LOT — PartConsumption → SerialLotDetail
Part consumption has serial/lot details
- Source table: FLOG_TLGPC_PART_CONSUMP_DTL
- Target table: FLOG_TLGSL_SERIAL_LOT_DTL
- SQL join:
FLOG_TLGPC_PART_CONSUMP_DTL.tlgpc_key_seq_no = FLOG_TLGSL_SERIAL_LOT_DTL.TLGSL_PART_KEY_SEQ_NO - Inference:
parent_pk_in_child
HAS_COM_SKILL — CertificateOfMaintenance → COMSkill
Certificate has skill details
- Source table: FLOG_TLGCOM_TECH_COM_DTL
- Target table: FLOG_TLGSKL_COM_SKILL_DTL
- SQL join:
FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_Com_NO = FLOG_TLGSKL_COM_SKILL_DTL.TLgSkl_Com_NO - Inference:
parent_pk_in_child
HAS_EXECUTION_COMMENT — Task → ExecutionComment
Task has execution comments
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGEC_EXCOMM_HIST
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGEC_EXCOMM_HIST.TLGECH_WU_Track_id - Inference:
parent_pk_in_child
HAS_SIGNOFF_COMMENT — Task → SignOffComment
Task has sign-off comments
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: FLOG_TLGSC_SOCOMM_HIST
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGSC_SOCOMM_HIST.TLGSCH_WU_Track_id - Inference:
parent_pk_in_child
HAS_ISSUE_RETURN — Task → IssueReturn
Task has issue/return records
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: fl_tlissret_issue_dtl
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = fl_tlissret_issue_dtl.TLISSRET_Task_Track_ID - Inference:
parent_pk_in_child
HAS_BENCH_STOCK — Task → BenchStockConsump
Task has bench stock consumption
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: flog_rbsc_bench_stk_cons_dtl
- SQL join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_rbsc_bench_stk_cons_dtl.rbsc_track_id - Inference:
parent_pk_in_child
SUBTASK_HAS_SIGNOFF — SubTask → SubTaskSignOff
Subtask has sign-off record
- Source table: FLOG_TLGWU_SUBTSK_DTL
- Target table: FLOG_TLGSTSO_SUBTSK_SNOFF
- SQL join:
FLOG_TLGWU_SUBTSK_DTL.TLGSBTSK_SUBTsk_Uniqueid = FLOG_TLGSTSO_SUBTSK_SNOFF.TLGSTSO_SUBTSK_Uniqueid - Inference:
parent_pk_in_child
HAS_TIME_BOOKING — Task → TimeBooking (no automatic join)
Task has time booking records
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: TA_TD_TIMEBOOKING_DTL
HAS_MATERIAL_REQUEST — Task → MaterialRequest (no automatic join)
Task has material request
- Source table: FLOG_TLGWU_WORK_UNIT_DTL
- Target table: MR_MRMN_MATRL_REQ_MAIN_HDR