APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1842: FROM mtl_serial_numbers

1838: CURSOR mtl_srl_num_csr(p_org_id In NUMBER,
1839: p_inv_id IN NUMBER,
1840: p_serial_number IN VARCHAR2) IS
1841: SELECT current_subinventory_code, current_locator_id
1842: FROM mtl_serial_numbers
1843: WHERE serial_number = p_serial_number
1844: AND current_organization_id = p_org_id
1845: AND inventory_item_id = p_inv_id
1846: AND current_status = 3;

Line 1905: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;

1901: AND ENABLED_FLAG = 'Y'
1902: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))
1903: AND ((END_DATE_ACTIVE IS NULL) OR (END_DATE_ACTIVE >= SYSDATE));
1904:
1905: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;
1906: l_curr_locator_id NUMBER;
1907: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
1908: l_quantity NUMBER;
1909: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

Line 2711: -- that from mtl_serial_numbers.

2707: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtltxn_rec.Serial_Number||']');
2708: END IF;
2709:
2710: -- For issue txn with serial number, validate if subinventory and locator match
2711: -- that from mtl_serial_numbers.
2712: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND
2713: (p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
2714: (nvl(l_serial_Control,0) <> 1) AND
2715: (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

Line 2909: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

2905: l_txn_source_type NUMBER;
2906: l_transaction_Mode NUMBER;
2907: l_Srl_Txn_Tmp_Id NUMBER;
2908: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2909: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
2910: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
2911:
2912: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
2913:

Line 3765: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

3761: IF G_DEBUG='Y' THEN
3762: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['
3763: ||to_char(l_txn_tmp_id)||']');
3764: END IF;
3765: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
3766: TRANSACTION_INTERFACE_ID, SOURCE_CODE, SOURCE_LINE_ID,
3767: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
3768: CREATED_BY, LAST_UPDATE_LOGIN, FM_SERIAL_NUMBER,
3769: TO_SERIAL_NUMBER, PROCESS_FLAG)

Line 5501: FROM mtl_serial_numbers msn, mtl_reservations rsv

5497: p_inventory_item_id IN NUMBER,
5498: p_organization_id IN NUMBER) IS
5499: SELECT rsv.DEMAND_SOURCE_LINE_DETAIL schedule_material_id, rsv.demand_source_header_id,
5500: rsv.demand_source_line_id, rsv.demand_source_type_id
5501: FROM mtl_serial_numbers msn, mtl_reservations rsv
5502: WHERE msn.reservation_id = rsv.reservation_id
5503: AND msn.serial_number = p_serial_number
5504: AND msn.current_organization_id = p_organization_id
5505: AND msn.inventory_item_id = p_inventory_item_id;