DBA Data[Home] [Help]

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 1054: FROM wip_entities we

1050:
1051: x_return_status := l_return_status;
1052:
1053: SELECT wip_entity_name into l_prior_workorder
1054: FROM wip_entities we
1055: WHERE we.wip_entity_id = l_prior_object_id;
1056:
1057: SELECT wip_entity_name into l_next_workorder
1058: FROM wip_entities we

Line 1058: FROM wip_entities we

1054: FROM wip_entities we
1055: WHERE we.wip_entity_id = l_prior_object_id;
1056:
1057: SELECT wip_entity_name into l_next_workorder
1058: FROM wip_entities we
1059: WHERE we.wip_entity_id = l_next_object_id;
1060:
1061:
1062: -- Validate that the relationship is a leaf node

Line 1267: FROM wip_entities we

1263:
1264: SAVEPOINT EAM_WN_ADD_DEP;
1265:
1266: SELECT wip_entity_name into l_prior_workorder
1267: FROM wip_entities we
1268: WHERE we.wip_entity_id = l_prior_object_id;
1269:
1270: SELECT wip_entity_name into l_next_workorder
1271: FROM wip_entities we

Line 1271: FROM wip_entities we

1267: FROM wip_entities we
1268: WHERE we.wip_entity_id = l_prior_object_id;
1269:
1270: SELECT wip_entity_name into l_next_workorder
1271: FROM wip_entities we
1272: WHERE we.wip_entity_id = l_next_object_id;
1273:
1274:
1275: -- Check that both work orders are part of

Line 1694: FROM wip_entities we

1690:
1691: x_return_status := FND_API.G_RET_STS_SUCCESS;
1692:
1693: SELECT wip_entity_name into l_parent_workorder
1694: FROM wip_entities we
1695: WHERE we.wip_entity_id = l_parent_object_id;
1696:
1697: SELECT wip_entity_name into l_child_workorder
1698: FROM wip_entities we

Line 1698: FROM wip_entities we

1694: FROM wip_entities we
1695: WHERE we.wip_entity_id = l_parent_object_id;
1696:
1697: SELECT wip_entity_name into l_child_workorder
1698: FROM wip_entities we
1699: WHERE we.wip_entity_id = l_child_object_id;
1700:
1701:
1702: -- See if there are dependency relationships for the child