APPS.EAM_COMPLETION dependencies on WIP_DISCRETE_JOBS

Line 476: FROM wip_discrete_jobs

472: rebuild_serial_number, parent_wip_entity_id, asset_number,
473: asset_group_id, manual_rebuild_flag, primary_item_id, status_type,
474: completion_subinventory, completion_locator_id, lot_number,
475: project_id, task_id
476: FROM wip_discrete_jobs
477: WHERE wip_entity_id = P_WIP_ENTITY_ID
478: FOR UPDATE OF status_type NOWAIT;
479: Recinfo C%ROWTYPE;
480:

Line 946: | from wip_discrete_jobs wdj, wip_entities we

942: /* --replaced with select statement for bug #2414513.
943: | -- Cursor to hold all child jobs information
944: | cursor child_jobs_cursor(c_wip_entity_id NUMBER) is
945: | select we.wip_entity_name, wdj.status_type
946: | from wip_discrete_jobs wdj, wip_entities we
947: | where wdj.wip_entity_id = we.wip_entity_id
948: | and wdj.parent_wip_entity_id = c_wip_entity_id
949: | and wdj.manual_rebuild_flag = 'Y';
950: |

Line 1020: -- get some value from wip_discrete_jobs table

1016:
1017: l_statement := 35;
1018: x_statement := l_statement;
1019:
1020: -- get some value from wip_discrete_jobs table
1021: select wdj.parent_wip_entity_id,
1022: wdj.asset_group_id,
1023: wdj.asset_number,
1024: wdj.primary_item_id,

Line 1055: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we

1051: l_old_system_status,
1052: l_old_eam_status,
1053: l_workflow_type,
1054: l_wip_entity_name
1055: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we
1056: where wdj.wip_entity_id = x_wip_entity_id
1057: AND wdj.wip_entity_id = ewod.wip_entity_id(+)
1058: AND wdj.wip_entity_id = we.wip_entity_id;
1059:

Line 1108: FROM wip_discrete_jobs

1104: SELECT '1'
1105: INTO network_child_job_var
1106: FROM dual
1107: WHERE EXISTS (SELECT '1'
1108: FROM wip_discrete_jobs
1109: WHERE wip_entity_id IN
1110: (
1111: SELECT DISTINCT child_object_id
1112: FROM eam_wo_relationships

Line 1128: FROM wip_discrete_jobs

1124: SELECT wip_entity_name
1125: INTO network_child_name
1126: FROM wip_entities
1127: where wip_entity_id= (SELECT wip_entity_id
1128: FROM wip_discrete_jobs
1129: WHERE wip_entity_id IN
1130: ( SELECT DISTINCT child_object_id
1131: FROM eam_wo_relationships
1132: WHERE parent_relationship_type =1

Line 1162: FROM wip_discrete_jobs

1158: SELECT '1'
1159: INTO sibling_parent_job_var
1160: FROM dual
1161: WHERE EXISTS (SELECT '1'
1162: FROM wip_discrete_jobs
1163: WHERE wip_entity_id IN
1164: (
1165: SELECT DISTINCT parent_object_id
1166: FROM eam_wo_relationships

Line 1181: FROM wip_discrete_jobs

1177: SELECT wip_entity_name
1178: INTO network_child_name
1179: FROM wip_entities
1180: where wip_entity_id= (SELECT wip_entity_id
1181: FROM wip_discrete_jobs
1182: WHERE wip_entity_id IN
1183: ( SELECT DISTINCT parent_object_id
1184: FROM eam_wo_relationships
1185: WHERE parent_relationship_type =2 and

Line 1385: FROM wip_discrete_jobs wdj, wip_entities we

1381: SELECT '1'
1382: INTO child_job_var
1383: FROM dual
1384: WHERE EXISTS (SELECT '1'
1385: FROM wip_discrete_jobs wdj, wip_entities we
1386: WHERE wdj.wip_entity_id = we.wip_entity_id
1387: AND wdj.parent_wip_entity_id = x_wip_entity_id
1388: AND wdj.manual_rebuild_flag = 'Y'
1389: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

Line 1480: from wip_discrete_jobs

1476: else
1477: -- get parent work order status
1478: begin -- Handled the exception for bug#2762312
1479: select status_type into i_parent_status_type
1480: from wip_discrete_jobs
1481: where wip_entity_id = i_parent_wip_entity_id;
1482: exception
1483: when NO_DATA_FOUND then
1484: null;

Line 1746: -- Update wip_discrete_jobs table

1742: end if; -- end insert check
1743: l_statement := 85;
1744: x_statement := l_statement;
1745:
1746: -- Update wip_discrete_jobs table
1747: update wip_discrete_jobs
1748: set last_update_date = sysdate,
1749: last_updated_by = x_user_id,
1750: last_update_login = x_user_id,

Line 1747: update wip_discrete_jobs

1743: l_statement := 85;
1744: x_statement := l_statement;
1745:
1746: -- Update wip_discrete_jobs table
1747: update wip_discrete_jobs
1748: set last_update_date = sysdate,
1749: last_updated_by = x_user_id,
1750: last_update_login = x_user_id,
1751: status_type = i_status_type,