APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 191: FROM BOM_OPERATIONAL_ROUTINGS

187: INTO x_rtg_seq_id,
188: p_alt_rtg,
189: p_default_subinv,
190: p_default_loc_id
191: FROM BOM_OPERATIONAL_ROUTINGS
192: WHERE common_routing_sequence_id = p_common_rtg_seq_id
193: AND organization_id = p_org_id
194: AND assembly_item_id = l_rtg_item_id
195: AND routing_type = 1

Line 5897: from bom_operational_routings bor

5893: END IF;
5894:
5895: select count(1)
5896: into l_row_exists
5897: from bom_operational_routings bor
5898: where bor.assembly_item_id= l_item_id
5899: and bor.organization_id= p_txn_org_id
5900: and bor.routing_type = 1
5901: and bor.cfm_routing_flag = 3

Line 6457: l_completion_subinventory BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY%type;

6453: x_msg_count OUT NOCOPY NUMBER,
6454: x_msg_data OUT NOCOPY VARCHAR2
6455: ) is
6456:
6457: l_completion_subinventory BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY%type;
6458: l_completion_locator_id number;
6459:
6460: l_sub_loc_control number;
6461: l_org_loc_control number;

Line 6581: from bom_operational_routings bor

6577: BEGIN
6578:
6579: select bor.completion_subinventory, bor.completion_locator_id
6580: into l_completion_subinventory,l_completion_locator_id
6581: from bom_operational_routings bor
6582: where bor.organization_id = p_organization_id
6583: and bor.common_routing_sequence_id = p_new_rtg_seq_id
6584: -- ST : Fix for bug 5094555 start --
6585: and nvl(bor.alternate_routing_designator,'@@@@****') = nvl(p_rj_alt_rtg_designator,'@@@@****')