DBA Data[Home] [Help]

APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_SECONDARY_INVENTORIES

Line 1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;

1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1641:
1642: l_group_id rcv_headers_interface.group_id%TYPE;

Line 2059: FROM MTL_SECONDARY_INVENTORIES msi

2055: --get the LOCATOR_TYPE column of the subinventory
2056: BEGIN
2057: SELECT msi.locator_type
2058: INTO l_locator_type
2059: FROM MTL_SECONDARY_INVENTORIES msi
2060: WHERE msi.Organization_Id = p_inventory_org_id
2061: AND msi.SECONDARY_INVENTORY_NAME = l_dest_subinventory;
2062: EXCEPTION
2063: WHEN no_data_found THEN