APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_ENTITIES

Line 155: FROM wip_entities we

151: x_return_status := l_return_status;
152:
153:
154: SELECT wip_entity_name into l_parent_workorder
155: FROM wip_entities we
156: WHERE we.wip_entity_id = l_parent_object_id;
157:
158: SELECT wip_entity_name into l_child_workorder
159: FROM wip_entities we

Line 159: FROM wip_entities we

155: FROM wip_entities we
156: WHERE we.wip_entity_id = l_parent_object_id;
157:
158: SELECT wip_entity_name into l_child_workorder
159: FROM wip_entities we
160: WHERE we.wip_entity_id = l_child_object_id;
161:
162: -- Validations for input parameters
163:

Line 1080: FROM wip_entities we

1076:
1077: x_return_status := l_return_status;
1078:
1079: SELECT wip_entity_name into l_prior_workorder
1080: FROM wip_entities we
1081: WHERE we.wip_entity_id = l_prior_object_id;
1082:
1083: SELECT wip_entity_name into l_next_workorder
1084: FROM wip_entities we

Line 1084: FROM wip_entities we

1080: FROM wip_entities we
1081: WHERE we.wip_entity_id = l_prior_object_id;
1082:
1083: SELECT wip_entity_name into l_next_workorder
1084: FROM wip_entities we
1085: WHERE we.wip_entity_id = l_next_object_id;
1086:
1087:
1088: -- Validate that the relationship is a leaf node

Line 1293: FROM wip_entities we

1289:
1290: SAVEPOINT EAM_WN_ADD_DEP;
1291:
1292: SELECT wip_entity_name into l_prior_workorder
1293: FROM wip_entities we
1294: WHERE we.wip_entity_id = l_prior_object_id;
1295:
1296: SELECT wip_entity_name into l_next_workorder
1297: FROM wip_entities we

Line 1297: FROM wip_entities we

1293: FROM wip_entities we
1294: WHERE we.wip_entity_id = l_prior_object_id;
1295:
1296: SELECT wip_entity_name into l_next_workorder
1297: FROM wip_entities we
1298: WHERE we.wip_entity_id = l_next_object_id;
1299:
1300:
1301: -- Check that both work orders are part of

Line 1720: FROM wip_entities we

1716:
1717: x_return_status := FND_API.G_RET_STS_SUCCESS;
1718:
1719: SELECT wip_entity_name into l_parent_workorder
1720: FROM wip_entities we
1721: WHERE we.wip_entity_id = l_parent_object_id;
1722:
1723: SELECT wip_entity_name into l_child_workorder
1724: FROM wip_entities we

Line 1724: FROM wip_entities we

1720: FROM wip_entities we
1721: WHERE we.wip_entity_id = l_parent_object_id;
1722:
1723: SELECT wip_entity_name into l_child_workorder
1724: FROM wip_entities we
1725: WHERE we.wip_entity_id = l_child_object_id;
1726:
1727:
1728: -- See if there are dependency relationships for the child