DBA Data[Home] [Help]

APPS.WIP_FLOW_DERIVE dependencies on BOM_OPERATIONAL_ROUTINGS

Line 173: from BOM_OPERATIONAL_ROUTINGS BOR

169: if p_comp_sub is null then
170:
171: select BOR.COMPLETION_SUBINVENTORY
172: into p_comp_sub
173: from BOM_OPERATIONAL_ROUTINGS BOR
174: where BOR.ORGANIZATION_ID = p_org_id
175: and BOR.ASSEMBLY_ITEM_ID = p_item_id
176: and NVL(BOR.ALTERNATE_ROUTING_DESIGNATOR,'@@@') =
177: NVL(p_alt_rtg_des, '@@@');

Line 210: from BOM_OPERATIONAL_ROUTINGS BOR

206: select BOR.COMPLETION_SUBINVENTORY,
207: BOR.COMPLETION_LOCATOR_ID
208: into p_rout_comp_sub,
209: p_rout_comp_loc
210: from BOM_OPERATIONAL_ROUTINGS BOR
211: where BOR.ORGANIZATION_ID = p_org_id
212: and BOR.ASSEMBLY_ITEM_ID = p_item_id
213: and NVL(BOR.ALTERNATE_ROUTING_DESIGNATOR,'@@@') =
214: NVL(p_alt_rtg_des, '@@@') ;