APPS.CTO_WIP_WRAPPER dependencies on WIP_ENTITIES

Line 123: | from wip_discrete_jobs dj, wip_entities we|

119: |
120: | original query
121: | select dj.wip_entity_id, we.wip_entity_name
122: | into l_wip_entity_id, l_job_name
123: | from wip_discrete_jobs dj, wip_entities we|
124: | where dj.wip_entity_id = we.wip_entity_id
125: | and dj.source_line_id = l_line_id
126: | and dj.source_code = 'WICDOL'
127: |

Line 1344: l_job_name wip_entities.wip_entity_name%type;

1340: END IF;
1341:
1342: -- Try to get the job info if it was created..
1343: declare
1344: l_job_name wip_entities.wip_entity_name%type;
1345: l_wip_entity_id wip_entities.wip_entity_id%type;
1346: begin
1347:
1348: l_stmt_num := 9;

Line 1345: l_wip_entity_id wip_entities.wip_entity_id%type;

1341:
1342: -- Try to get the job info if it was created..
1343: declare
1344: l_job_name wip_entities.wip_entity_name%type;
1345: l_wip_entity_id wip_entities.wip_entity_id%type;
1346: begin
1347:
1348: l_stmt_num := 9;
1349:

Line 1352: from wip_discrete_jobs dj, wip_entities we,

1348: l_stmt_num := 9;
1349:
1350: select dj.wip_entity_id, we.wip_entity_name
1351: into l_wip_entity_id, l_job_name
1352: from wip_discrete_jobs dj, wip_entities we,
1353: oe_order_lines_all oel
1354: where dj.wip_entity_id = we.wip_entity_id
1355: and dj.source_line_id = l_line_id
1356: and dj.source_code = 'WICDOL'