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 1018: -- get some value from wip_discrete_jobs table

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

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

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

Line 1105: FROM wip_discrete_jobs

1101: SELECT '1'
1102: INTO network_child_job_var
1103: FROM dual
1104: WHERE EXISTS (SELECT '1'
1105: FROM wip_discrete_jobs
1106: WHERE wip_entity_id IN
1107: (
1108: SELECT DISTINCT child_object_id
1109: FROM eam_wo_relationships

Line 1140: FROM wip_discrete_jobs

1136: SELECT '1'
1137: INTO sibling_parent_job_var
1138: FROM dual
1139: WHERE EXISTS (SELECT '1'
1140: FROM wip_discrete_jobs
1141: WHERE wip_entity_id IN
1142: (
1143: SELECT DISTINCT parent_object_id
1144: FROM eam_wo_relationships

Line 1344: FROM wip_discrete_jobs wdj, wip_entities we

1340: SELECT '1'
1341: INTO child_job_var
1342: FROM dual
1343: WHERE EXISTS (SELECT '1'
1344: FROM wip_discrete_jobs wdj, wip_entities we
1345: WHERE wdj.wip_entity_id = we.wip_entity_id
1346: AND wdj.parent_wip_entity_id = x_wip_entity_id
1347: AND wdj.manual_rebuild_flag = 'Y'
1348: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

Line 1436: from wip_discrete_jobs

1432: else
1433: -- get parent work order status
1434: begin -- Handled the exception for bug#2762312
1435: select status_type into i_parent_status_type
1436: from wip_discrete_jobs
1437: where wip_entity_id = i_parent_wip_entity_id;
1438: exception
1439: when NO_DATA_FOUND then
1440: null;

Line 1699: -- Update wip_discrete_jobs table

1695: end if; -- end insert check
1696: l_statement := 85;
1697: x_statement := l_statement;
1698:
1699: -- Update wip_discrete_jobs table
1700: update wip_discrete_jobs
1701: set last_update_date = sysdate,
1702: last_updated_by = x_user_id,
1703: last_update_login = x_user_id,

Line 1700: update wip_discrete_jobs

1696: l_statement := 85;
1697: x_statement := l_statement;
1698:
1699: -- Update wip_discrete_jobs table
1700: update wip_discrete_jobs
1701: set last_update_date = sysdate,
1702: last_updated_by = x_user_id,
1703: last_update_login = x_user_id,
1704: status_type = i_status_type,