APPS.INV_GMI_MIGRATION dependencies on MTL_MATERIAL_STATUS_S

Line 814: FROM mtl_material_statuses_tl

810: BEGIN
811: -- Check if the material status already exists in the discrete
812: SELECT count(*)
813: INTO l_count
814: FROM mtl_material_statuses_tl
815: WHERE
816: status_code = l_lot_status.lot_status and
817: rownum = 1;
818:

Line 838: SELECT mtl_material_status_s.NEXTVAL

834: p_app_short_name => 'GMI');
835: raise FND_API.G_EXC_ERROR;
836: END IF;
837:
838: SELECT mtl_material_status_s.NEXTVAL
839: INTO l_status_id
840: FROM DUAL;
841:
842: l_availability_type := 2;

Line 848: MTL_MATERIAL_STATUSES_PKG.INSERT_ROW (

844: IF (l_lot_status.nettable_ind = 1) THEN
845: l_availability_type := 1;
846: END IF;
847: END IF;
848: MTL_MATERIAL_STATUSES_PKG.INSERT_ROW (
849: X_ROWID => l_rowid,
850: X_STATUS_ID => l_status_id,
851: X_ATTRIBUTE1 => NULL,
852: X_ATTRIBUTE2 => NULL,