APPS.INV_TXN_MANAGER_GRP dependencies on MTL_ITEM_LOCATIONS

Line 5744: FROM mtl_item_locations

5740:
5741: IF (l_project_enabled = 1 and p_locatorid is not null) THEN --If the Org is Project enabled Org
5742: BEGIN
5743: SELECT project_id INTO l_project_id
5744: FROM mtl_item_locations
5745: WHERE organization_id =p_org_id
5746: AND inventory_location_id = p_locatorid;
5747: EXCEPTION
5748: WHEN no_data_found THEN

Line 5801: FROM MTL_ITEM_LOCATIONS

5797: BEGIN
5798:
5799: begin
5800: SELECT 1 INTO l_count
5801: FROM MTL_ITEM_LOCATIONS
5802: WHERE ORGANIZATION_ID = p_orgid
5803: /* Start: Fix for Bug# 7323175 : Also considering the physical locator for locking */
5804: AND INVENTORY_LOCATION_ID = p_locid
5805: --AND INVENTORY_LOCATION_ID IN (p_locid,p_plocid)

Line 5817: UPDATE MTL_ITEM_LOCATIONS

5813: END IF;
5814: end;
5815:
5816: IF (l_count = 1) THEN
5817: UPDATE MTL_ITEM_LOCATIONS
5818: SET LAST_UPDATE_DATE = SYSDATE,
5819: LAST_UPDATED_BY = p_userid,
5820: LAST_UPDATE_LOGIN = p_loginid,
5821: PROGRAM_APPLICATION_ID = p_applid,

Line 7144: UPDATE MTL_ITEM_LOCATIONS

7140: , l_locid);
7141: /* Added one more parameter l_plocid for Bug# 7323175 to update_mil() for the physical locator */
7142:
7143: ELSE
7144: UPDATE MTL_ITEM_LOCATIONS
7145: SET LAST_UPDATE_DATE = SYSDATE,
7146: LAST_UPDATED_BY = p_userid,
7147: LAST_UPDATE_LOGIN = p_loginid,
7148: PROGRAM_APPLICATION_ID = p_applid,

Line 7328: MTL_ITEM_LOCATIONS MIL

7324: BEGIN
7325: SELECT LOCATOR_ID
7326: INTO l_xlocid
7327: FROM MTL_ITEM_LOC_DEFAULTS MTLD,
7328: MTL_ITEM_LOCATIONS MIL
7329: WHERE MTLD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID
7330: AND MTLD.ORGANIZATION_ID=MIL.ORGANIZATION_ID
7331: AND MTLD.INVENTORY_ITEM_ID = l_itemid
7332: AND MTLD.ORGANIZATION_ID = l_xorgid

Line 7410: UPDATE MTL_ITEM_LOCATIONS

7406: , l_xorgid
7407: , l_xlocid);
7408: /* Addded a parameter l_xplocid for Bug# 7323175 in update_mil */
7409: ELSE
7410: UPDATE MTL_ITEM_LOCATIONS
7411: SET LAST_UPDATE_DATE = SYSDATE,
7412: LAST_UPDATED_BY = p_userid,
7413: LAST_UPDATE_LOGIN = p_loginid,
7414: PROGRAM_APPLICATION_ID = p_applid,

Line 8476: FROM MTL_ITEM_LOCATIONS MIL

8472: AND PROCESS_FLAG = 1
8473: AND LOCATOR_ID IS NOT NULL
8474: AND NOT EXISTS (
8475: SELECT NULL
8476: FROM MTL_ITEM_LOCATIONS MIL
8477: WHERE MIL.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8478: AND MIL.SUBINVENTORY_CODE = MTI.SUBINVENTORY_CODE
8479: AND MIL.INVENTORY_LOCATION_ID = MTI.LOCATOR_ID
8480: AND TRUNC(MTI.TRANSACTION_DATE) <= NVL(MIL.DISABLE_DATE,

Line 8544: FROM MTL_ITEM_LOCATIONS MIL

8540: AND TRANSACTION_ACTION_ID IN (2,3,5)
8541: AND TRANSFER_LOCATOR IS NOT NULL
8542: AND NOT EXISTS (
8543: SELECT NULL
8544: FROM MTL_ITEM_LOCATIONS MIL
8545: WHERE MIL.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,3,
8546: MTI.TRANSFER_ORGANIZATION,MTI.ORGANIZATION_ID)
8547: AND MIL.SUBINVENTORY_CODE = MTI.TRANSFER_SUBINVENTORY
8548: AND MIL.INVENTORY_LOCATION_ID = MTI.TRANSFER_LOCATOR