DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 1059: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1055:
1056: IF(l_wo_status=17) THEN
1057: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1058: l_WipEntityId_tbl,l_workorder_status_tbl
1059: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1060: WHERE wsr.parent_object_id=p_work_object_id
1061: AND wsr.parent_object_type_id= p_work_object_type_id
1062: AND wsr.child_object_type_id=p_work_object_type_id
1063: AND wsr.child_object_id=wdj.wip_entity_id

Line 1071: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1067: AND lk.lookup_code = wdj.status_type;
1068: ELSIF(l_wo_status=1) THEN
1069: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1070: l_WipEntityId_tbl,l_workorder_status_tbl
1071: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1072: WHERE wsr.parent_object_id=p_work_object_id
1073: AND wsr.parent_object_type_id= p_work_object_type_id
1074: AND wsr.child_object_type_id=p_work_object_type_id
1075: AND wsr.child_object_id=wdj.wip_entity_id

Line 1083: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1079: AND lk.lookup_code = wdj.status_type;
1080: ELSIF(l_wo_status IN (3,6)) THEN
1081: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1082: l_WipEntityId_tbl,l_workorder_status_tbl
1083: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1084: WHERE wsr.parent_object_id=p_work_object_id
1085: AND wsr.parent_object_type_id= p_work_object_type_id
1086: AND wsr.child_object_type_id=p_work_object_type_id
1087: AND wsr.child_object_id=wdj.wip_entity_id

Line 1095: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1091: AND lk.lookup_code = wdj.status_type;
1092: ELSIF(l_wo_status=7) THEN
1093: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1094: l_WipEntityId_tbl,l_workorder_status_tbl
1095: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1096: WHERE wsr.parent_object_id=p_work_object_id
1097: AND wsr.parent_object_type_id= p_work_object_type_id
1098: AND wsr.child_object_type_id=p_work_object_type_id
1099: AND wsr.child_object_id=wdj.wip_entity_id

Line 1107: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1103: AND lk.lookup_code = wdj.status_type;
1104: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
1105: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1106: l_WipEntityId_tbl,l_workorder_status_tbl
1107: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1108: WHERE wsr.parent_object_id=p_work_object_id
1109: AND wsr.parent_object_type_id= p_work_object_type_id
1110: AND wsr.child_object_type_id=p_work_object_type_id
1111: AND wsr.child_object_id=wdj.wip_entity_id