APPS.WSM_RESERVATIONS_GRP dependencies on WIP_DISCRETE_JOBS

Line 64: l_item_id wip_discrete_jobs.primary_item_id%TYPE; --bug 4633035

60: /* local variable for debug purpose */
61: l_stmt_num NUMBER := 0;
62: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
63: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
64: l_item_id wip_discrete_jobs.primary_item_id%TYPE; --bug 4633035
65:
66: BEGIN
67:
68: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 94: FROM WIP_DISCRETE_JOBS WDJ

90:
91: l_stmt_num := 30;
92: SELECT WDJ.NET_QUANTITY,WDJ.PRIMARY_ITEM_ID
93: INTO x_available_quantity,l_item_id
94: FROM WIP_DISCRETE_JOBS WDJ
95: WHERE WDJ.WIP_ENTITY_ID = p_supply_demand_header_id;
96:
97: l_stmt_num := 40;
98: select primary_uom_code

Line 196: wip_discrete_jobs wdj

192: l_scheduled_completion_date,
193: l_net_qty,
194: l_status_type
195: from wip_entities we,
196: wip_discrete_jobs wdj
197: where wdj.wip_entity_id = p_supply_demand_header_id
198: and we.wip_entity_id = wdj.wip_entity_id
199: and wdj.job_type in (1,3)
200: and we.entity_type = 5;