eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SERIAL_NUMBERS

Line 2131: FROM mtl_serial_numbers

2127: CURSOR mtl_srl_num_csr(p_org_id In NUMBER,
2128: p_inv_id IN NUMBER,
2129: p_serial_number IN VARCHAR2) IS
2130: SELECT current_subinventory_code, current_locator_id
2131: FROM mtl_serial_numbers
2132: WHERE serial_number = p_serial_number
2133: AND current_organization_id = p_org_id
2134: AND inventory_item_id = p_inv_id
2135: AND current_status = 3;

Line 2204: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;

2200: AND ENABLED_FLAG = 'Y'
2201: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE - 1))
2202: AND TRUNC(NVL(END_DATE_ACTIVE, SYSDATE));
2203:
2204: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;
2205: l_curr_locator_id NUMBER;
2206: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
2207: l_quantity NUMBER;
2208: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

Line 2275: FROM mtl_serial_numbers

2271: CURSOR mtl_serial_csr (p_inv_item_id IN NUMBER,
2272: p_serial_num IN VARCHAR2)
2273: IS
2274: SELECT 'x'
2275: FROM mtl_serial_numbers
2276: WHERE inventory_item_id = p_inv_item_id
2277: AND serial_number = p_serial_num
2278: AND current_status IN ('1','4'); -- defined, not used and 'out of stores'
2279:

Line 3266: -- that from mtl_serial_numbers.

3262: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtltxn_rec.Serial_Number||']');
3263: END IF;
3264:
3265: -- For issue txn with serial number, validate if subinventory and locator match
3266: -- that from mtl_serial_numbers.
3267: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND
3268: (p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
3269: (nvl(l_serial_Control,0) <> 1) AND
3270: (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

Line 3476: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

3472: l_txn_source_type NUMBER;
3473: l_transaction_Mode NUMBER;
3474: l_Srl_Txn_Tmp_Id NUMBER;
3475: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
3476: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
3477: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
3478:
3479: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
3480:

Line 4157: FROM mtl_serial_numbers

4153: D_ATTRIBUTE1, D_ATTRIBUTE2, D_ATTRIBUTE3, D_ATTRIBUTE4, D_ATTRIBUTE5,
4154: D_ATTRIBUTE6, D_ATTRIBUTE7, D_ATTRIBUTE8, D_ATTRIBUTE9, D_ATTRIBUTE10,
4155: N_ATTRIBUTE1, N_ATTRIBUTE2, N_ATTRIBUTE3, N_ATTRIBUTE4, N_ATTRIBUTE5,
4156: N_ATTRIBUTE6, N_ATTRIBUTE7, N_ATTRIBUTE8, N_ATTRIBUTE9, N_ATTRIBUTE10
4157: FROM mtl_serial_numbers
4158: where inventory_item_id = p_inv_item_id
4159: and serial_number = p_serial_number;
4160:
4161: l_serial_dff_rec get_serial_dff_attrib%ROWTYPE;

Line 4438: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

4434: ||to_char(l_txn_tmp_id)||']');
4435: END IF;
4436:
4437: -- Fix for bug # 8607839(FP for Bug # 8636342) -- start
4438: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
4439: TRANSACTION_INTERFACE_ID, SOURCE_CODE, SOURCE_LINE_ID,
4440: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
4441: CREATED_BY, LAST_UPDATE_LOGIN, FM_SERIAL_NUMBER,
4442: TO_SERIAL_NUMBER, PROCESS_FLAG,

Line 5174: l_inv_serial mtl_serial_numbers.serial_number%TYPE;

5170: l_reln_exists VARCHAR2(1);
5171: l_dup_disposition VARCHAR2(1);
5172: l_inv_item_id NUMBER;
5173: l_inv_rev mtl_material_transactions.revision%TYPE;
5174: l_inv_serial mtl_serial_numbers.serial_number%TYPE;
5175: l_inv_lot_no mtl_lot_numbers.lot_number%TYPE;
5176: l_wo_id NUMBER;
5177: l_track_flag BOOLEAN;
5178: l_cnt_disposition NUMBER;

Line 5189: FROM mtl_serial_numbers

5185: CURSOR mtl_serial_csr (p_inv_item_id IN NUMBER,
5186: p_serial_num IN VARCHAR2)
5187: IS
5188: SELECT 'x'
5189: FROM mtl_serial_numbers
5190: WHERE inventory_item_id = p_inv_item_id
5191: AND serial_number = p_serial_num
5192: AND current_status IN ('1','4');
5193:

Line 6709: SERIAL_NUM_STATUS mtl_serial_numbers.current_status%TYPE );

6705: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
6706: locator VARCHAR2(500),
6707:
6708: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE,
6709: SERIAL_NUM_STATUS mtl_serial_numbers.current_status%TYPE );
6710:
6711: l_mtl_txn_rec l_mtl_txn_rec_type;
6712:
6713: BEGIN

Line 6751: (select msn.current_status from mtl_serial_numbers msn where msn.inventory_item_id = C.INVENTORY_ITEM_ID and msn.serial_number = C.serial_number) serial_num_status

6747: || ''.''
6748: || DECODE(D.SEGMENT20, NULL,NULL,INV_PROJECT.GET_TASK_NUMBER(D.SEGMENT20)) LOCATOR,
6749:
6750: V.INV_LOCATOR_ID,
6751: (select msn.current_status from mtl_serial_numbers msn where msn.inventory_item_id = C.INVENTORY_ITEM_ID and msn.serial_number = C.serial_number) serial_num_status
6752: FROM AHL_WORKORDERS W,
6753: FND_LOOKUP_VALUES_VL MLU,
6754: MTL_SYSTEM_ITEMS_KFV I,
6755: AHL_VISITS_B V,

Line 7246: FROM mtl_serial_numbers msn, mtl_reservations rsv

7242: p_inventory_item_id IN NUMBER,
7243: p_organization_id IN NUMBER) IS
7244: SELECT rsv.DEMAND_SOURCE_LINE_DETAIL schedule_material_id, rsv.demand_source_header_id,
7245: rsv.demand_source_line_id, rsv.demand_source_type_id
7246: FROM mtl_serial_numbers msn, mtl_reservations rsv
7247: WHERE msn.reservation_id = rsv.reservation_id
7248: AND msn.serial_number = p_serial_number
7249: AND msn.current_organization_id = p_organization_id
7250: AND msn.inventory_item_id = p_inventory_item_id;