DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1716: g_exception_tracking_msg := 'Quering BOM_OPERATIONAL_ROUTINGS table for Sub Inventory and Locator ID';

1712: END IF;
1713:
1714: IF p_process_type= 'JOB_CREATION' AND l_mode = 2 THEN
1715:
1716: g_exception_tracking_msg := 'Quering BOM_OPERATIONAL_ROUTINGS table for Sub Inventory and Locator ID';
1717:
1718: SELECT COMPLETION_SUBINVENTORY,COMPLETION_LOCATOR_ID
1719: INTO l_comp_sub_inventory,l_comp_locator_id
1720: FROM BOM_OPERATIONAL_ROUTINGS

Line 1720: FROM BOM_OPERATIONAL_ROUTINGS

1716: g_exception_tracking_msg := 'Quering BOM_OPERATIONAL_ROUTINGS table for Sub Inventory and Locator ID';
1717:
1718: SELECT COMPLETION_SUBINVENTORY,COMPLETION_LOCATOR_ID
1719: INTO l_comp_sub_inventory,l_comp_locator_id
1720: FROM BOM_OPERATIONAL_ROUTINGS
1721: WHERE assembly_item_id = l_prev_inventory_item_id
1722: AND organization_id = p_org_id
1723: AND ((ALTERNATE_ROUTING_DESIGNATOR = p_hdr_rec.alt_routing_designator) OR (ALTERNATE_ROUTING_DESIGNATOR IS NULL));
1724: