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 1200: l_job_name wip_entities.wip_entity_name%type;

1196: END IF;
1197:
1198: -- Try to get the job info if it was created..
1199: declare
1200: l_job_name wip_entities.wip_entity_name%type;
1201: l_wip_entity_id wip_entities.wip_entity_id%type;
1202: begin
1203:
1204: l_stmt_num := 9;

Line 1201: l_wip_entity_id wip_entities.wip_entity_id%type;

1197:
1198: -- Try to get the job info if it was created..
1199: declare
1200: l_job_name wip_entities.wip_entity_name%type;
1201: l_wip_entity_id wip_entities.wip_entity_id%type;
1202: begin
1203:
1204: l_stmt_num := 9;
1205:

Line 1208: from wip_discrete_jobs dj, wip_entities we,

1204: l_stmt_num := 9;
1205:
1206: select dj.wip_entity_id, we.wip_entity_name
1207: into l_wip_entity_id, l_job_name
1208: from wip_discrete_jobs dj, wip_entities we,
1209: oe_order_lines_all oel
1210: where dj.wip_entity_id = we.wip_entity_id
1211: and dj.source_line_id = l_line_id
1212: and dj.source_code = 'WICDOL'