DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on MTL_SYSTEM_ITEMS

Line 22: MTL_SYSTEM_ITEMS msi

18: GL_SETS_OF_BOOKS gsob,
19: WIP_DISCRETE_JOBS wdj,
20: WIP_REPETITIVE_SCHEDULES wrs,
21: EDW_LOCAL_INSTANCE inst,
22: MTL_SYSTEM_ITEMS msi
23: WHERE
24: wor.organization_id = wo.organization_id
25: and wor.wip_entity_id = wo.wip_entity_id
26: and wor.operation_seq_num = wo.operation_seq_num

Line 67: MTL_SYSTEM_ITEMS msi

63: WIP_FLOW_SCHEDULES wfs,
64: BOM_OPERATIONAL_ROUTINGS bor,
65: BOM_OPERATION_SEQUENCES bos,
66: EDW_LOCAL_INSTANCE inst,
67: MTL_SYSTEM_ITEMS msi
68: WHERE
69: wt.transaction_type in (1,3)
70: and wfs.status = 2
71: and wt.wip_entity_id = wfs.wip_entity_id