DBA Data[Home] [Help]

APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_SECONDARY_INVENTORIES

Line 1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;

1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1621:
1622: l_group_id rcv_headers_interface.group_id%TYPE;

Line 2039: FROM MTL_SECONDARY_INVENTORIES msi

2035: --get the LOCATOR_TYPE column of the subinventory
2036: BEGIN
2037: SELECT msi.locator_type
2038: INTO l_locator_type
2039: FROM MTL_SECONDARY_INVENTORIES msi
2040: WHERE msi.Organization_Id = p_inventory_org_id
2041: AND msi.SECONDARY_INVENTORY_NAME = l_dest_subinventory;
2042: EXCEPTION
2043: WHEN no_data_found THEN