APPS.AHL_CMP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 463: FROM mtl_serial_numbers

459: CURSOR mtl_srl_num_csr(p_org_id In NUMBER,
460: p_inv_id IN NUMBER,
461: p_serial_number IN VARCHAR2) IS
462: SELECT current_subinventory_code, current_locator_id
463: FROM mtl_serial_numbers
464: WHERE serial_number = p_serial_number
465: AND current_organization_id = p_org_id
466: AND inventory_item_id = p_inv_id
467: AND current_status = 3;

Line 489: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;

485: where TRANSACTION_TYPE_ID = p_type_Id;
486:
487:
488: l_txn_type VARCHAR2(80);
489: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;
490: l_curr_locator_id NUMBER;
491: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
492: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
493: l_junk VARCHAR2(1);

Line 750: -- that from mtl_serial_numbers.

746: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtlxfr_rec.Serial_Number||']');
747: END IF;
748:
749: -- For issue txn with serial number, validate if subinventory and locator match
750: -- that from mtl_serial_numbers.
751: IF (p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) AND (nvl(l_serial_Control,0) <> 1) THEN
752: OPEN mtl_srl_num_csr(p_x_ahl_mtlxfr_rec.Organization_ID,
753: p_x_ahl_mtlxfr_rec.Inventory_Item_id,
754: p_x_ahl_mtlxfr_rec.Serial_Number);

Line 861: FROM mtl_serial_numbers

857: D_ATTRIBUTE1, D_ATTRIBUTE2, D_ATTRIBUTE3, D_ATTRIBUTE4, D_ATTRIBUTE5,
858: D_ATTRIBUTE6, D_ATTRIBUTE7, D_ATTRIBUTE8, D_ATTRIBUTE9, D_ATTRIBUTE10,
859: N_ATTRIBUTE1, N_ATTRIBUTE2, N_ATTRIBUTE3, N_ATTRIBUTE4, N_ATTRIBUTE5,
860: N_ATTRIBUTE6, N_ATTRIBUTE7, N_ATTRIBUTE8, N_ATTRIBUTE9, N_ATTRIBUTE10
861: FROM mtl_serial_numbers
862: where inventory_item_id = p_inv_item_id
863: and serial_number = p_serial_number;
864:
865: l_serial_dff_rec get_serial_dff_attrib%ROWTYPE;

Line 1048: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1044: ||to_char(l_txn_tmp_id)||']');
1045: END IF;
1046:
1047:
1048: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1049: TRANSACTION_INTERFACE_ID, SOURCE_CODE, SOURCE_LINE_ID,
1050: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
1051: CREATED_BY, LAST_UPDATE_LOGIN, FM_SERIAL_NUMBER,
1052: TO_SERIAL_NUMBER, PROCESS_FLAG,