DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on WIP_LINES

Line 127: WIP_LINES wflow_wl

123: FROM WIP_FLOW_SCHEDULES wflow,
124: WIP_ENTITIES wflow_we,
125: MTL_ITEM_LOCATIONS_KFV wflow_loc,
126: MTL_KANBAN_CARDS wflow_mkc,
127: WIP_LINES wflow_wl
128: WHERE wflow.wip_entity_id = l_wip_entity_id
129: AND Wflow.wip_entity_id = wflow_we.wip_entity_id
130: AND NVL(p_locator_id,wflow.completion_locator_id) = wflow_loc.inventory_location_id(+)
131: AND Wflow.kanban_card_id = wflow_mkc.kanban_card_id(+)

Line 330: WIP_LINES bom_rte_wl

326: bom_rte_pp.name project_name,
327: bom_rte_pt.task_name
328: FROM BOM_OPERATIONAL_ROUTINGS bom_rte,
329: PA_PROJECTS bom_rte_pp, PA_TASKS bom_rte_pt,
330: WIP_LINES bom_rte_wl
331: WHERE bom_rte.assembly_item_id = p_inventory_item_id
332: AND bom_rte.organization_id = p_organization_id
333: AND nvl(bom_rte.alternate_routing_designator, '@@@') = nvl(p_alternate_routing_designator, '@@@')
334: AND bom_rte.project_id = bom_rte_pp.project_id(+)