APPS.INV_TXN_MANAGER_GRP dependencies on MTL_ITEM_LOCATIONS

Line 5365: FROM mtl_item_locations

5361:
5362: IF (l_project_enabled = 1 and p_locatorid is not null) THEN --If the Org is Project enabled Org
5363: BEGIN
5364: SELECT project_id INTO l_project_id
5365: FROM mtl_item_locations
5366: WHERE organization_id =p_org_id
5367: AND inventory_location_id = p_locatorid;
5368: EXCEPTION
5369: WHEN no_data_found THEN

Line 5422: FROM MTL_ITEM_LOCATIONS

5418: BEGIN
5419:
5420: begin
5421: SELECT 1 INTO l_count
5422: FROM MTL_ITEM_LOCATIONS
5423: WHERE ORGANIZATION_ID = p_orgid
5424: /* Start: Fix for Bug# 7323175 : Also considering the physical locator for locking */
5425: --AND INVENTORY_LOCATION_ID = p_locid
5426: AND INVENTORY_LOCATION_ID IN (p_locid,p_plocid)

Line 5438: UPDATE MTL_ITEM_LOCATIONS

5434: END IF;
5435: end;
5436:
5437: IF (l_count = 1) THEN
5438: UPDATE MTL_ITEM_LOCATIONS
5439: SET LAST_UPDATE_DATE = SYSDATE,
5440: LAST_UPDATED_BY = p_userid,
5441: LAST_UPDATE_LOGIN = p_loginid,
5442: PROGRAM_APPLICATION_ID = p_applid,

Line 6691: UPDATE MTL_ITEM_LOCATIONS

6687: , l_plocid);
6688: /* Added one more parameter l_plocid for Bug# 7323175 to update_mil() for the physical locator */
6689:
6690: ELSE
6691: UPDATE MTL_ITEM_LOCATIONS
6692: SET LAST_UPDATE_DATE = SYSDATE,
6693: LAST_UPDATED_BY = p_userid,
6694: LAST_UPDATE_LOGIN = p_loginid,
6695: PROGRAM_APPLICATION_ID = p_applid,

Line 6846: MTL_ITEM_LOCATIONS MIL

6842: BEGIN
6843: SELECT LOCATOR_ID
6844: INTO l_xlocid
6845: FROM MTL_ITEM_LOC_DEFAULTS MTLD,
6846: MTL_ITEM_LOCATIONS MIL
6847: WHERE MTLD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID
6848: AND MTLD.ORGANIZATION_ID=MIL.ORGANIZATION_ID
6849: AND MTLD.INVENTORY_ITEM_ID = l_itemid
6850: AND MTLD.ORGANIZATION_ID = l_xorgid

Line 6961: UPDATE MTL_ITEM_LOCATIONS

6957: , l_xlocid
6958: , l_xplocid);
6959: /* Addded a parameter l_xplocid for Bug# 7323175 in update_mil */
6960: ELSE
6961: UPDATE MTL_ITEM_LOCATIONS
6962: SET LAST_UPDATE_DATE = SYSDATE,
6963: LAST_UPDATED_BY = p_userid,
6964: LAST_UPDATE_LOGIN = p_loginid,
6965: PROGRAM_APPLICATION_ID = p_applid,

Line 7979: FROM MTL_ITEM_LOCATIONS MIL

7975: AND PROCESS_FLAG = 1
7976: AND LOCATOR_ID IS NOT NULL
7977: AND NOT EXISTS (
7978: SELECT NULL
7979: FROM MTL_ITEM_LOCATIONS MIL
7980: WHERE MIL.ORGANIZATION_ID = MTI.ORGANIZATION_ID
7981: AND MIL.SUBINVENTORY_CODE = MTI.SUBINVENTORY_CODE
7982: AND MIL.INVENTORY_LOCATION_ID = MTI.LOCATOR_ID
7983: AND TRUNC(MTI.TRANSACTION_DATE) <= NVL(MIL.DISABLE_DATE,

Line 8047: FROM MTL_ITEM_LOCATIONS MIL

8043: AND TRANSACTION_ACTION_ID IN (2,3,5)
8044: AND TRANSFER_LOCATOR IS NOT NULL
8045: AND NOT EXISTS (
8046: SELECT NULL
8047: FROM MTL_ITEM_LOCATIONS MIL
8048: WHERE MIL.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,3,
8049: MTI.TRANSFER_ORGANIZATION,MTI.ORGANIZATION_ID)
8050: AND MIL.SUBINVENTORY_CODE = MTI.TRANSFER_SUBINVENTORY
8051: AND MIL.INVENTORY_LOCATION_ID = MTI.TRANSFER_LOCATOR